Query

database.sqlite — agents_observations

SQL

CREATE TABLE "agents_observations"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "agentId" varchar(36) NOT NULL,
  "observationScopeId" varchar(255) NOT NULL,
  "marker" varchar(16) NOT NULL,
  "text" text NOT NULL,
  "parentId" varchar(36),
  "tokenCount" integer NOT NULL DEFAULT (0),
  "status" varchar(16) NOT NULL,
  "supersededBy" varchar(36),
  "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_agents_observations_marker" CHECK ("marker" IN ('critical', 'important', 'info', 'completion')),
  CONSTRAINT "CHK_agents_observations_status" CHECK ("status" IN ('active', 'superseded', 'dropped')),
  CONSTRAINT "FK_d206432be97b7ed88d187479b1b" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_4cfd8a70ebb0a5b0cf047dca3cf" FOREIGN KEY ("observationScopeId") REFERENCES "agents_threads" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_501e2d1701a10e24fb69ab5fc5f" FOREIGN KEY ("parentId") REFERENCES "agents_observations" ("id"),
  CONSTRAINT "FK_127ee1078ffa952bb37b511efad" FOREIGN KEY ("supersededBy") REFERENCES "agents_observations" ("id")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
agentId varchar(36) Rename | Drop
observationScopeId varchar(255) Rename | Drop
marker varchar(16) Rename | Drop
text TEXT Rename | Drop
parentId varchar(36) ✓ Rename | Drop
tokenCount INTEGER Rename | Drop
status varchar(16) Rename | Drop
supersededBy varchar(36) ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
supersededBy agents_observations.id
parentId agents_observations.id
observationScopeId agents_threads.id
agentId agents.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_07cb1e4a302629c5fa5d74d2bb
  • agentId
  • observationScopeId
  • status
 SQL 
CREATE INDEX "IDX_07cb1e4a302629c5fa5d74d2bb"
ON "agents_observations" ("agentId", "observationScopeId", "status")
Drop
IDX_127ee1078ffa952bb37b511efa supersededBy SQL 
CREATE INDEX "IDX_127ee1078ffa952bb37b511efa"
ON "agents_observations" ("supersededBy")
Drop
IDX_4cfd8a70ebb0a5b0cf047dca3c observationScopeId SQL 
CREATE INDEX "IDX_4cfd8a70ebb0a5b0cf047dca3c"
ON "agents_observations" ("observationScopeId")
Drop
IDX_501e2d1701a10e24fb69ab5fc5 parentId SQL 
CREATE INDEX "IDX_501e2d1701a10e24fb69ab5fc5"
ON "agents_observations" ("parentId")
Drop
sqlite_autoindex_agents_observations_1 id ✓ SQL
-- no sql found --
 Drop