Query

database.sqlite — binary_data

+/- table definition

Query 

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'))
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop