Query

database.sqlite — agent_background_job

SQL

CREATE TABLE "agent_background_job"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "kind" varchar(16) NOT NULL,
  "status" varchar(16) NOT NULL,
  "parentAgentId" varchar(36) NOT NULL,
  "parentThreadId" varchar(128) NOT NULL,
  "title" varchar(255) NOT NULL,
  "subAgentId" varchar(36),
  "childThreadId" varchar(128),
  "childExecutionId" varchar(36),
  "workflowId" varchar(36),
  "timeoutAt" datetime(3),
  "result" text,
  "error" text,
  "settledAt" datetime(3),
  "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_background_job_kind" CHECK ("kind" IN ('subagent', 'workflow')),
  CONSTRAINT "CHK_agent_background_job_status" CHECK ("status" IN ('running', 'completed', 'failed', 'cancelled')),
  CONSTRAINT "FK_d46c6f00730c2ef8bcb6ee24b67" FOREIGN KEY ("parentAgentId") REFERENCES "agents" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
kind varchar(16) Rename | Drop
status varchar(16) Rename | Drop
parentAgentId varchar(36) Rename | Drop
parentThreadId varchar(128) Rename | Drop
title varchar(255) Rename | Drop
subAgentId varchar(36) ✓ Rename | Drop
childThreadId varchar(128) ✓ Rename | Drop
childExecutionId varchar(36) ✓ Rename | Drop
workflowId varchar(36) ✓ Rename | Drop
timeoutAt datetime(3) ✓ Rename | Drop
result TEXT ✓ Rename | Drop
error TEXT ✓ Rename | Drop
settledAt datetime(3) ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
parentAgentId agents.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_93d62baabe9858816b5adafb44
  • parentThreadId
  • status
 SQL 
CREATE INDEX "IDX_93d62baabe9858816b5adafb44"
ON "agent_background_job" ("parentThreadId", "status")
Drop
IDX_agent_background_job_childExecutionId childExecutionId ✓ SQL 
CREATE UNIQUE INDEX "IDX_agent_background_job_childExecutionId"
ON "agent_background_job" ("childExecutionId") WHERE "childExecutionId" IS NOT NULL
Drop
IDX_agent_background_job_timeoutAt timeoutAt SQL 
CREATE INDEX "IDX_agent_background_job_timeoutAt"
ON "agent_background_job" ("timeoutAt") WHERE "status" = 'running'
Drop
IDX_d46c6f00730c2ef8bcb6ee24b6 parentAgentId SQL 
CREATE INDEX "IDX_d46c6f00730c2ef8bcb6ee24b6"
ON "agent_background_job" ("parentAgentId")
Drop
IDX_e43e630272995a93dfeb94ab3e settledAt SQL 
CREATE INDEX "IDX_e43e630272995a93dfeb94ab3e"
ON "agent_background_job" ("settledAt")
Drop
sqlite_autoindex_agent_background_job_1 id ✓ SQL
-- no sql found --
 Drop