chatrpg-api/sql/turns.sql

CREATE TABLE IF NOT EXISTS turns(
    id UUID PRIMARY KEY,
    session_id UUID NOT NULL REFERENCES sessions(id) ON DELETE CASCADE,
    user_text TEXT NOT NULL,
    llm_text TEXT NOT NULL,
    tokens_used INTEGER NOT NULL,
    created_at TIMESTAMPTZ NOT NULL
);