Query

database.sqlite — agents_memory_entry_s...

SQL

CREATE TABLE "agents_memory_entry_sources"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "agentId" varchar(36) NOT NULL,
  "memoryEntryId" varchar(36) NOT NULL,
  "observationId" varchar(36) NOT NULL,
  "threadId" varchar(255) NOT NULL,
  "evidenceHash" varchar(64) NOT NULL,
  "evidenceText" text 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 "FK_c38e8a57a36b880e39a52ada2e8" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_4706f6223313959b7437a2b48df" FOREIGN KEY ("memoryEntryId") REFERENCES "agents_memory_entries" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_cb7c15d22fd068a0806aa57fc03" FOREIGN KEY ("observationId") REFERENCES "agents_observations" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_451d387a182fa8dd8002dfc3a77" FOREIGN KEY ("threadId") REFERENCES "agents_threads" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
agentId varchar(36) Rename | Drop
memoryEntryId varchar(36) Rename | Drop
observationId varchar(36) Rename | Drop
threadId varchar(255) Rename | Drop
evidenceHash varchar(64) Rename | Drop
evidenceText TEXT Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
threadId agents_threads.id
observationId agents_observations.id
memoryEntryId agents_memory_entries.id
agentId agents.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_451d387a182fa8dd8002dfc3a7 threadId SQL 
CREATE INDEX "IDX_451d387a182fa8dd8002dfc3a7"
ON "agents_memory_entry_sources" ("threadId")
Drop
IDX_a353ac251315ef0af6ad3c9f0a
  • memoryEntryId
  • observationId
  • evidenceHash
 ✓ SQL 
CREATE UNIQUE INDEX "IDX_a353ac251315ef0af6ad3c9f0a"
ON "agents_memory_entry_sources" ("memoryEntryId", "observationId", "evidenceHash")
Drop
IDX_cb7c15d22fd068a0806aa57fc0 observationId SQL 
CREATE INDEX "IDX_cb7c15d22fd068a0806aa57fc0"
ON "agents_memory_entry_sources" ("observationId")
Drop
IDX_f9573af4ed653f13b0ba1f7b12
  • agentId
  • threadId
 SQL 
CREATE INDEX "IDX_f9573af4ed653f13b0ba1f7b12"
ON "agents_memory_entry_sources" ("agentId", "threadId")
Drop
sqlite_autoindex_agents_memory_entry_sources_1 id ✓ SQL
-- no sql found --
 Drop