Query

database.sqlite — agent_eval_dataset

SQL

CREATE TABLE "agent_eval_dataset"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "name" varchar(128) NOT NULL,
  "description" text,
  "agentId" varchar(36) NOT NULL,
  "datasetSource" varchar(32) NOT NULL,
  "datasetRef" text NOT NULL,
  "columnMapping" text,
  "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_dataset_datasetSource" CHECK ("datasetSource" IN ('data_table', 'google_sheets')),
  CONSTRAINT "FK_9d3a6fd750f7746de453cf4d5ed" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_eda9e5fa5558d3f16bc2f6c21b6" FOREIGN KEY ("createdById") REFERENCES "user" ("id") ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
name varchar(128) Rename | Drop
description TEXT ✓ Rename | Drop
agentId varchar(36) Rename | Drop
datasetSource varchar(32) Rename | Drop
datasetRef TEXT Rename | Drop
columnMapping TEXT ✓ Rename | Drop
createdById varchar ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
createdById user.id
agentId agents.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_9d3a6fd750f7746de453cf4d5e agentId SQL 
CREATE INDEX "IDX_9d3a6fd750f7746de453cf4d5e"
ON "agent_eval_dataset" ("agentId")
Drop
sqlite_autoindex_agent_eval_dataset_1 id ✓ SQL
-- no sql found --
 Drop