SQL
CREATE TABLE "agent_eval_run" (
"id" varchar(36) PRIMARY KEY NOT NULL,
"datasetId" varchar(36) NOT NULL,
"agentVersionId" varchar(36),
"status" varchar NOT NULL,
"runAt" datetime(3),
"completedAt" datetime(3),
"metrics" text,
"errorCode" varchar(255),
"errorDetails" text,
"runningInstanceId" varchar(255),
"cancelRequested" boolean NOT NULL DEFAULT (false),
"createdById" varchar,
"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_run_status" CHECK ("status" IN ('new', 'running', 'completed', 'error', 'cancelled')),
CONSTRAINT "FK_39ca447735d378e365f4227abff" FOREIGN KEY ("datasetId") REFERENCES "agent_eval_dataset" ("id") ON DELETE CASCADE,
CONSTRAINT "FK_54ee897f442cc7393a6d6165334" FOREIGN KEY ("createdById") REFERENCES "user" ("id") ON DELETE SET NULL
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
varchar(36) |
✓ | Rename | Drop | |
datasetId |
varchar(36) |
Rename | Drop | ||
agentVersionId |
varchar(36) |
✓ | Rename | Drop | |
status |
varchar |
Rename | Drop | ||
runAt |
datetime(3) |
✓ | Rename | Drop | |
completedAt |
datetime(3) |
✓ | Rename | Drop | |
metrics |
TEXT |
✓ | Rename | Drop | |
errorCode |
varchar(255) |
✓ | Rename | Drop | |
errorDetails |
TEXT |
✓ | Rename | Drop | |
runningInstanceId |
varchar(255) |
✓ | Rename | Drop | |
cancelRequested |
boolean |
Rename | Drop | ||
createdById |
varchar |
✓ | Rename | Drop | |
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
createdById |
user.id |
datasetId |
agent_eval_dataset.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| IDX_39ca447735d378e365f4227abf |
datasetId
|
SQL | Drop | |
| sqlite_autoindex_agent_eval_run_1 |
id
|
✓ | SQL | Drop |