chatrpg-api/sql/characters.sql

CREATE TABLE IF NOT EXISTS characters(
    id UUID PRIMARY KEY,
    game_id UUID NOT NULL REFERENCES games(id) ON DELETE CASCADE,
    name TEXT NOT NULL,
    description TEXT NOT NULL
);