Query

database.sqlite — agents_memory_entries

SQL

CREATE TABLE "agents_memory_entries"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "agentId" varchar(36) NOT NULL,
  "resourceId" varchar(255) NOT NULL,
  "content" text NOT NULL,
  "contentHash" varchar(64) NOT NULL,
  "status" varchar(16) NOT NULL,
  "supersededBy" varchar(36),
  "embeddingModel" varchar(128),
  "embedding" text,
  "metadata" text,
  "lastSeenAt" datetime(3) NOT NULL,
  "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_memory_entries_status" CHECK ("status" IN ('active', 'superseded', 'dropped')),
  CONSTRAINT "FK_28e981fb675e9b44ce02f0ec1dd" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_1443a75e59adbfb796071d66393" FOREIGN KEY ("resourceId") REFERENCES "agents_resources" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_0edf1226b77ddc525eae4938079" FOREIGN KEY ("supersededBy") REFERENCES "agents_memory_entries" ("id")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
agentId varchar(36) Rename | Drop
resourceId varchar(255) Rename | Drop
content TEXT Rename | Drop
contentHash varchar(64) Rename | Drop
status varchar(16) Rename | Drop
supersededBy varchar(36) ✓ Rename | Drop
embeddingModel varchar(128) ✓ Rename | Drop
embedding TEXT ✓ Rename | Drop
metadata TEXT ✓ Rename | Drop
lastSeenAt datetime(3) Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
supersededBy agents_memory_entries.id
resourceId agents_resources.id
agentId agents.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_0edf1226b77ddc525eae493807 supersededBy SQL 
CREATE INDEX "IDX_0edf1226b77ddc525eae493807"
ON "agents_memory_entries" ("supersededBy")
Drop
IDX_1443a75e59adbfb796071d6639 resourceId SQL 
CREATE INDEX "IDX_1443a75e59adbfb796071d6639"
ON "agents_memory_entries" ("resourceId")
Drop
IDX_a03e04e94bea8439dd166d4b52
  • agentId
  • resourceId
  • contentHash
 ✓ SQL 
CREATE UNIQUE INDEX "IDX_a03e04e94bea8439dd166d4b52"
ON "agents_memory_entries" ("agentId", "resourceId", "contentHash")
Drop
IDX_aff2807b31eccbafe59d0474f0
  • agentId
  • resourceId
  • status
  • createdAt
  • id
 SQL 
CREATE INDEX "IDX_aff2807b31eccbafe59d0474f0"
ON "agents_memory_entries" ("agentId", "resourceId", "status", "createdAt", "id")
Drop
sqlite_autoindex_agents_memory_entries_1 id ✓ SQL
-- no sql found --
 Drop