Query

database.sqlite — agent_eval_result

SQL

CREATE TABLE "agent_eval_result"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "runId" varchar(36) NOT NULL,
  "sourceRowId" varchar(255),
  "runIndex" integer,
  "status" varchar NOT NULL,
  "input" text,
  "output" text,
  "toolCalls" text,
  "metrics" text,
  "runAt" datetime(3),
  "completedAt" datetime(3),
  "errorCode" varchar(255),
  "errorDetails" text,
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  CONSTRAINT "CHK_agent_eval_result_status" CHECK ("status" IN ('new', 'running', 'success', 'error', 'cancelled')),
  CONSTRAINT "FK_40a2d1248a6d984f442de2fac1b" FOREIGN KEY ("runId") REFERENCES "agent_eval_run" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
runId varchar(36) Rename | Drop
sourceRowId varchar(255) ✓ Rename | Drop
runIndex INTEGER ✓ Rename | Drop
status varchar Rename | Drop
input TEXT ✓ Rename | Drop
output TEXT ✓ Rename | Drop
toolCalls TEXT ✓ Rename | Drop
metrics TEXT ✓ Rename | Drop
runAt datetime(3) ✓ Rename | Drop
completedAt datetime(3) ✓ Rename | Drop
errorCode varchar(255) ✓ Rename | Drop
errorDetails TEXT ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
runId agent_eval_run.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_40a2d1248a6d984f442de2fac1 runId SQL 
CREATE INDEX "IDX_40a2d1248a6d984f442de2fac1"
ON "agent_eval_result" ("runId")
Drop
sqlite_autoindex_agent_eval_result_1 id ✓ SQL
-- no sql found --
 Drop