--up

CREATE TABLE faq_answers (
    id integer GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    answer text NOT NULL
);

CREATE TABLE faq_questions (
    id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    answer_id integer NOT NULL REFERENCES faq_answers (id),
    question text NOT NULL,
    embedding vector(1536)
);

--down

DROP TABLE faq_questions;
DROP TABLE faq_answers;
