Query

database.sqlite — agent_execution

SQL

CREATE TABLE "agent_execution"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "threadId" varchar(128) NOT NULL,
  "status" varchar(16) NOT NULL,
  "startedAt" datetime(3),
  "stoppedAt" datetime(3),
  "duration" integer NOT NULL DEFAULT (0),
  "userMessage" text,
  "model" varchar(255),
  "promptTokens" integer,
  "completionTokens" integer,
  "totalTokens" integer,
  "cost" real,
  "timeline" text,
  "error" text,
  "hitlStatus" varchar(16),
  "source" varchar(32),
  "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')),
  "storedAt" varchar(2) NOT NULL DEFAULT ('db'),
  "attachments" text,
  "failureSummary" text,
  CONSTRAINT "CHK_agent_execution_storedAt" CHECK ((("storedAt" IN ('db', 'fs', 's3', 'az')))),
  CONSTRAINT "CHK_agent_execution_hitlStatus" CHECK (((((("hitlStatus" IN ('suspended', 'resumed'))))))),
  CONSTRAINT "CHK_agent_execution_status" CHECK (("status" IN ('running', 'success', 'error', 'cancelled', 'interrupted'))),
  CONSTRAINT "FK_add2432fb6034cc18b6af299dce" FOREIGN KEY ("threadId") REFERENCES "agent_execution_threads" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
threadId varchar(128) Rename | Drop
status varchar(16) Rename | Drop
startedAt datetime(3) ✓ Rename | Drop
stoppedAt datetime(3) ✓ Rename | Drop
duration INTEGER Rename | Drop
userMessage TEXT ✓ Rename | Drop
model varchar(255) ✓ Rename | Drop
promptTokens INTEGER ✓ Rename | Drop
completionTokens INTEGER ✓ Rename | Drop
totalTokens INTEGER ✓ Rename | Drop
cost REAL ✓ Rename | Drop
timeline TEXT ✓ Rename | Drop
error TEXT ✓ Rename | Drop
hitlStatus varchar(16) ✓ Rename | Drop
source varchar(32) ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop
storedAt varchar(2) Rename | Drop
attachments TEXT ✓ Rename | Drop
failureSummary TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
threadId agent_execution_threads.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_63d3c3a68b9cebf05f967f0b1c
  • threadId
  • createdAt
 SQL 
CREATE INDEX "IDX_63d3c3a68b9cebf05f967f0b1c"
ON "agent_execution" ("threadId", "createdAt")
Drop
IDX_agent_execution_status status SQL 
CREATE INDEX "IDX_agent_execution_status"
ON "agent_execution" ("status") WHERE "status" = 'running'
Drop
sqlite_autoindex_agent_execution_1 id ✓ SQL
-- no sql found --
 Drop