Query

app.db — chatbot_eval_run_rows

SQL

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)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
run_id INTEGER Rename | Drop
row_index INTEGER Rename | Drop
context TEXT ✓ Rename | Drop
question TEXT Rename | Drop
expected_answer TEXT ✓ Rename | Drop
response TEXT ✓ Rename | Drop
ok INTEGER Rename | Drop
error TEXT ✓ Rename | Drop
trace_json TEXT ✓ Rename | Drop
manual_score INTEGER ✓ Rename | Drop
manual_valid INTEGER ✓ Rename | Drop
manual_notes TEXT ✓ Rename | Drop
graded_at TEXT ✓ Rename | Drop
graded_by_user_id INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
graded_by_user_id users.id
run_id chatbot_eval_runs.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_eval_run_rows_run
  • run_id
  • row_index
 SQL 
CREATE INDEX idx_eval_run_rows_run
ON chatbot_eval_run_rows(run_id, row_index)
Drop
sqlite_autoindex_chatbot_eval_run_rows_1
  • run_id
  • row_index
 ✓ SQL
-- no sql found --
 Drop