Query

database.sqlite — agent_chat_attachments

SQL

CREATE TABLE "agent_chat_attachments"  (
  "id" varchar(16) PRIMARY KEY NOT NULL,
  "agentId" varchar(36),
  "projectId" varchar(36) NOT NULL,
  "threadId" varchar(128) NOT NULL,
  "resourceId" varchar(255),
  "binaryDataId" text NOT NULL,
  "fileName" varchar(255) NOT NULL,
  "mimeType" varchar(255) NOT NULL,
  "fileSizeBytes" integer NOT NULL,
  "source" varchar(32) 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_41c246c30af3d2108d93e15dd5e" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_5c048535b2132b40dfed2e640e5" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(16) ✓ Rename | Drop
agentId varchar(36) ✓ Rename | Drop
projectId varchar(36) Rename | Drop
threadId varchar(128) Rename | Drop
resourceId varchar(255) ✓ Rename | Drop
binaryDataId TEXT Rename | Drop
fileName varchar(255) Rename | Drop
mimeType varchar(255) Rename | Drop
fileSizeBytes INTEGER Rename | Drop
source varchar(32) Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
projectId project.id
agentId agents.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_6806b43c8a0d11460f0c2552eb
  • projectId
  • threadId
 SQL 
CREATE INDEX "IDX_6806b43c8a0d11460f0c2552eb"
ON "agent_chat_attachments" ("projectId", "threadId")
Drop
IDX_7e9556f25f995653997be3322b
  • agentId
  • threadId
 SQL 
CREATE INDEX "IDX_7e9556f25f995653997be3322b"
ON "agent_chat_attachments" ("agentId", "threadId")
Drop
sqlite_autoindex_agent_chat_attachments_1 id ✓ SQL
-- no sql found --
 Drop