Execution Entity · SQLite Schema · n8n-io/n8n · Skills Docs

Execution Entity · SQLite Schema · n8n-io/n8n · Skills Docs

CREATE TABLE "execution_entity" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "workflowId" varchar(36) NOT NULL, "finished" boolean NOT NULL, "mode" varchar NOT NULL, "retryOf" varchar, "retrySuccessId" varchar, "startedAt" datetime, "stoppedAt" datetime, "waitTill" datetime, "status" varchar NOT NULL, "deletedAt" datetime(3), "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "storedAt" varchar(2) NOT NULL DEFAULT ('db'), "tracingContext" text, "deduplicationKey" varchar(255), "jsonSizeBytes" bigint NOT NULL DEFAULT (0), "workflowVersionId" varchar(36) DEFAULT (NULL), "binaryDataSizeBytes" bigint NOT NULL DEFAULT (0), "usedPrivateCredentials" BOOLEAN NOT NULL DEFAULT FALSE, "resumeAttempts" SMALLINT NOT NULL DEFAULT 0, CONSTRAINT "CHK_execution_entity_storedAt" CHECK ("storedAt" IN ('db', 'fs', 's3', 'az')), CONSTRAINT "FK_c4d999a5e90784e8caccf5589de" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE CASCADE ON UPDATE NO ACTION)

Name	Type	Default	Nullable	Children	Parents	Comment
binaryDataSizeBytes	bigint	0	false
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
deduplicationKey	varchar(255)		true
deletedAt	datetime(3)		true
finished	boolean		false
id	INTEGER		false	chat_hub_messages execution_annotations execution_data execution_metadata test_case_execution
jsonSizeBytes	bigint	0	false
mode	varchar		false
resumeAttempts	SMALLINT	0	false
retryOf	varchar		true
retrySuccessId	varchar		true
startedAt	datetime		true
status	varchar		false
stoppedAt	datetime		true
storedAt	varchar(2)	‘db’	false
tracingContext	TEXT		true
usedPrivateCredentials	BOOLEAN	FALSE	false
waitTill	datetime		true
workflowId	varchar(36)		false		workflow_entity
workflowVersionId	varchar(36)	NULL	true

Name	Type	Definition
-	CHECK	CHECK (“storedAt” IN (‘db’, ‘fs’, ‘s3’, ‘az’))
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
IDX_execution_entity_deduplicationKey	CREATE UNIQUE INDEX “IDX_execution_entity_deduplicationKey” ON “execution_entity” (“deduplicationKey”) WHERE “deduplicationKey” IS NOT NULL
IDX_execution_entity_deletedAt	CREATE INDEX “IDX_execution_entity_deletedAt” ON “execution_entity” (“deletedAt”)
IDX_execution_entity_stoppedAt	CREATE INDEX “IDX_execution_entity_stoppedAt” ON “execution_entity” (“stoppedAt”)
IDX_execution_entity_workflowId	CREATE INDEX “IDX_execution_entity_workflowId” ON “execution_entity” (“workflowId”)

erDiagram

"chat_hub_messages" }o--o| "execution_entity" : "FOREIGN KEY (executionId) REFERENCES execution_entity (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"execution_annotations" }o--|| "execution_entity" : "FOREIGN KEY (executionId) REFERENCES execution_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"execution_data" |o--|| "execution_entity" : "FOREIGN KEY (executionId) REFERENCES execution_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"execution_metadata" }o--|| "execution_entity" : "FOREIGN KEY (executionId) REFERENCES execution_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"test_case_execution" }o--o| "execution_entity" : "FOREIGN KEY (pastExecutionId) REFERENCES execution_entity (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"test_case_execution" }o--o| "execution_entity" : "FOREIGN KEY (executionId) REFERENCES execution_entity (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"test_case_execution" }o--o| "execution_entity" : "FOREIGN KEY (evaluationExecutionId) REFERENCES execution_entity (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"execution_entity" }o--|| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"execution_entity" {
  bigint binaryDataSizeBytes
  datetime_3_ createdAt
  varchar_255_ deduplicationKey
  datetime_3_ deletedAt