create table public.source_documents ( id uuid not null default gen_random_uuid (), created_at timestamp with time zone not null default now(), file_name text not null, storage_path text not null, public_url text not null, file_size bigint null, constraint source_documents_pkey primary key (id) );
create table public.quizzes ( id text not null, -- We generate ID in python, so text is fine created_at timestamp with time zone not null default now(), title text not null, document_id uuid null references public.source_documents (id) on delete set null, content jsonb not null default '[]'::jsonb, -- Stores the list of questions constraint quizzes_pkey primary key (id) );
create table public.explanations ( id text not null, created_at timestamp with time zone not null default now(), quiz_id text null references public.quizzes (id) on delete cascade, question_id text null, -- Logical link to a question ID inside the quiz JSON text text not null, context text null, -- The snippet of source text used to generate this constraint explanations_pkey primary key (id) );