Binary Data · SQLite Schema · n8n-io/n8n · Skills Docs

Binary Data · SQLite Schema · n8n-io/n8n · Skills Docs

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', 'agent_file', 'agent_chat_attachment', 'app_artifact')))

Name	Type	Default	Nullable	Children	Parents	Comment
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
data	BLOB		false
fileId	varchar		false
fileName	varchar(255)		true
fileSize	INTEGER		false
mimeType	varchar(255)		true
sourceId	varchar(255)		false
sourceType	varchar(50)		false
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false

Name	Type	Definition
-	CHECK	CHECK (“sourceType” IN (‘execution’, ‘chat_message_attachment’, ‘agent_file’, ‘agent_chat_attachment’, ‘app_artifact’))
fileId	PRIMARY KEY	PRIMARY KEY (fileId)
sqlite_autoindex_binary_data_1	PRIMARY KEY	PRIMARY KEY (fileId)

erDiagram


"binary_data" {
  datetime_3_ createdAt
  BLOB data
  varchar fileId PK
  varchar_255_ fileName
  INTEGER fileSize
  varchar_255_ mimeType
  varchar_255_ sourceId
  varchar_50_ sourceType
  datetime_3_ updatedAt
}