chatrpg-api/sql/characters.sql

CREATE TABLE IF NOT EXISTS characters(
    id UUID PRIMARY KEY,

    game_id UUID NOT NULL REFERENCES games(id),
    name TEXT NOT NULL,
    description TEXT NOT NULL
);