Query

app.db — chatbot_eval_runs

SQL

CREATE TABLE chatbot_eval_runs  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  chatbot_id INTEGER NOT NULL,
  created_by_user_id INTEGER NOT NULL,
  created_at TEXT NOT NULL,
  name TEXT,
  status TEXT NOT NULL DEFAULT 'completed',
  settings_snapshot_json TEXT,
  source_filename TEXT,
  row_count INTEGER NOT NULL DEFAULT 0,
  planned_row_count INTEGER,
  include_tool_outputs INTEGER NOT NULL DEFAULT 0,
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
  FOREIGN KEY (created_by_user_id) REFERENCES users(id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
chatbot_id INTEGER Rename | Drop
created_by_user_id INTEGER Rename | Drop
created_at TEXT Rename | Drop
name TEXT ✓ Rename | Drop
status TEXT Rename | Drop
settings_snapshot_json TEXT ✓ Rename | Drop
source_filename TEXT ✓ Rename | Drop
row_count INTEGER Rename | Drop
planned_row_count INTEGER ✓ Rename | Drop
include_tool_outputs INTEGER Rename | Drop

Foreign Keys

Column Destination
created_by_user_id users.id
chatbot_id chatbots.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_eval_runs_chatbot
  • chatbot_id
  • created_at
 SQL 
CREATE INDEX idx_eval_runs_chatbot
ON chatbot_eval_runs(chatbot_id, created_at DESC)
Drop