CREATE TABLE chatbot_eval_run_rows (
id INTEGER PRIMARY KEY AUTOINCREMENT,
run_id INTEGER NOT NULL,
row_index INTEGER NOT NULL,
context TEXT,
question TEXT NOT NULL,
expected_answer TEXT,
response TEXT,
ok INTEGER NOT NULL DEFAULT 0,
error TEXT,
trace_json TEXT,
manual_score INTEGER,
manual_valid INTEGER,
manual_notes TEXT,
graded_at TEXT,
graded_by_user_id INTEGER,
FOREIGN KEY (run_id) REFERENCES chatbot_eval_runs(id) ON DELETE CASCADE,
FOREIGN KEY (graded_by_user_id) REFERENCES users(id) ON DELETE SET NULL,
UNIQUE(run_id, row_index)
)