Query

database.sqlite — binary_data

SQL

CREATE TABLE "binary_data"  (
  "fileId" varchar PRIMARY KEY NOT NULL,
  "sourceType" varchar(50) NOT NULL,
  "sourceId" varchar(255) NOT NULL,
  "data" blob NOT NULL,
  "mimeType" varchar(255),
  "fileName" varchar(255),
  "fileSize" integer 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_binary_data_sourceType" CHECK ("sourceType" IN ('execution', 'chat_message_attachment'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
fileId varchar ✓ Rename | Drop
sourceType varchar(50) Rename | Drop
sourceId varchar(255) Rename | Drop
data BLOB Rename | Drop
mimeType varchar(255) ✓ Rename | Drop
fileName varchar(255) ✓ Rename | Drop
fileSize INTEGER Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_56900edc3cfd16612e2ef2c6a8
  • sourceType
  • sourceId
 SQL 
CREATE INDEX "IDX_56900edc3cfd16612e2ef2c6a8"
ON "binary_data" ("sourceType", "sourceId")
Drop
sqlite_autoindex_binary_data_1 fileId ✓ SQL
-- no sql found --
 Drop