chatrpg-api/sql/turns.sql

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