CREATE TABLE IF NOT EXISTS answer_attempts (
    id                  TEXT PRIMARY KEY,
    session_question_id TEXT NOT NULL REFERENCES session_questions(id),
    submitted_answer    TEXT NOT NULL,
    is_correct          INTEGER NOT NULL,
    similarity_score    REAL,
    submitted_at        TEXT NOT NULL DEFAULT (datetime('now'))
);