Query

database.sqlite — instance_ai_observati...

SQL

CREATE TABLE "instance_ai_observational_memory"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "lookupKey" varchar(255) NOT NULL,
  "scope" varchar(16) NOT NULL,
  "threadId" varchar,
  "resourceId" varchar(255) NOT NULL,
  "activeObservations" text NOT NULL DEFAULT (''),
  "originType" varchar(32) NOT NULL,
  "config" text NOT NULL,
  "generationCount" integer NOT NULL DEFAULT (0),
  "lastObservedAt" datetime(3),
  "pendingMessageTokens" integer NOT NULL DEFAULT (0),
  "totalTokensObserved" integer NOT NULL DEFAULT (0),
  "observationTokenCount" integer NOT NULL DEFAULT (0),
  "isObserving" boolean NOT NULL DEFAULT (false),
  "isReflecting" boolean NOT NULL DEFAULT (false),
  "observedMessageIds" text,
  "observedTimezone" varchar,
  "bufferedObservations" text,
  "bufferedObservationTokens" integer,
  "bufferedMessageIds" text,
  "bufferedReflection" text,
  "bufferedReflectionTokens" integer,
  "bufferedReflectionInputTokens" integer,
  "reflectedObservationLineCount" integer,
  "bufferedObservationChunks" text,
  "isBufferingObservation" boolean NOT NULL DEFAULT (false),
  "isBufferingReflection" boolean NOT NULL DEFAULT (false),
  "lastBufferedAtTokens" integer NOT NULL DEFAULT (0),
  "lastBufferedAtTime" datetime(3),
  "metadata" text,
  "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 "FK_34018c303885cd37093458e6409" FOREIGN KEY ("threadId") REFERENCES "instance_ai_threads" ("id") ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
lookupKey varchar(255) Rename | Drop
scope varchar(16) Rename | Drop
threadId varchar ✓ Rename | Drop
resourceId varchar(255) Rename | Drop
activeObservations TEXT Rename | Drop
originType varchar(32) Rename | Drop
config TEXT Rename | Drop
generationCount INTEGER Rename | Drop
lastObservedAt datetime(3) ✓ Rename | Drop
pendingMessageTokens INTEGER Rename | Drop
totalTokensObserved INTEGER Rename | Drop
observationTokenCount INTEGER Rename | Drop
isObserving boolean Rename | Drop
isReflecting boolean Rename | Drop
observedMessageIds TEXT ✓ Rename | Drop
observedTimezone varchar ✓ Rename | Drop
bufferedObservations TEXT ✓ Rename | Drop
bufferedObservationTokens INTEGER ✓ Rename | Drop
bufferedMessageIds TEXT ✓ Rename | Drop
bufferedReflection TEXT ✓ Rename | Drop
bufferedReflectionTokens INTEGER ✓ Rename | Drop
bufferedReflectionInputTokens INTEGER ✓ Rename | Drop
reflectedObservationLineCount INTEGER ✓ Rename | Drop
bufferedObservationChunks TEXT ✓ Rename | Drop
isBufferingObservation boolean Rename | Drop
isBufferingReflection boolean Rename | Drop
lastBufferedAtTokens INTEGER Rename | Drop
lastBufferedAtTime datetime(3) ✓ Rename | Drop
metadata TEXT ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
threadId instance_ai_threads.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_92f13cb6bc694227e069447f7b lookupKey SQL 
CREATE INDEX "IDX_92f13cb6bc694227e069447f7b"
ON "instance_ai_observational_memory" ("lookupKey")
Drop
IDX_a680ac96aae02dc887bbaac512
  • scope
  • threadId
  • resourceId
 ✓ SQL 
CREATE UNIQUE INDEX "IDX_a680ac96aae02dc887bbaac512"
ON "instance_ai_observational_memory" ("scope", "threadId", "resourceId")
Drop
sqlite_autoindex_instance_ai_observational_memory_1 id ✓ SQL
-- no sql found --
 Drop