chatrpg-api/sql/sessions.sql

CREATE TABLE IF NOT EXISTS sessions(
    id UUID PRIMARY KEY,
    game_id UUID NOT NULL REFERENCES games(id) ON DELETE CASCADE,
    summary TEXT NULL,
    started_at TIMESTAMPTZ NOT NULL,
    ended_at TIMESTAMPTZ NULL
);