Query

database.sqlite — instance_ai_observations

SQL

CREATE TABLE "instance_ai_observations"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "observationScopeId" varchar 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_instance_ai_observations_marker" CHECK ("marker" IN ('critical', 'important', 'info', 'completion')),
  CONSTRAINT "CHK_instance_ai_observations_status" CHECK ("status" IN ('active', 'superseded', 'dropped')),
  CONSTRAINT "FK_d54fc84a6c8ac91b5e0db0378a4" FOREIGN KEY ("observationScopeId") REFERENCES "instance_ai_threads" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_daef2195a4a846eb70eed15e039" FOREIGN KEY ("parentId") REFERENCES "instance_ai_observations" ("id"),
  CONSTRAINT "FK_a80e0ee839a2f10ba4b86e19998" FOREIGN KEY ("supersededBy") REFERENCES "instance_ai_observations" ("id")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
observationScopeId varchar 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 instance_ai_observations.id
parentId instance_ai_observations.id
observationScopeId instance_ai_threads.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_0d5db648188d338df7fb2a8064
  • observationScopeId
  • status
  • createdAt
  • id
 SQL 
CREATE INDEX "IDX_0d5db648188d338df7fb2a8064"
ON "instance_ai_observations" ("observationScopeId", "status", "createdAt", "id")
Drop
IDX_a80e0ee839a2f10ba4b86e1999 supersededBy SQL 
CREATE INDEX "IDX_a80e0ee839a2f10ba4b86e1999"
ON "instance_ai_observations" ("supersededBy")
Drop
IDX_daef2195a4a846eb70eed15e03 parentId SQL 
CREATE INDEX "IDX_daef2195a4a846eb70eed15e03"
ON "instance_ai_observations" ("parentId")
Drop
sqlite_autoindex_instance_ai_observations_1 id ✓ SQL
-- no sql found --
 Drop