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
)