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

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

CREATE TABLE "execution_ledger" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "executionId" varchar(36) NOT NULL, "occurredAt" datetime(3) NOT NULL, "entityType" varchar(16) NOT NULL, "entityName" varchar(128) NOT NULL, "entityId" varchar(36) NOT NULL, "projectId" varchar(36) NOT NULL, "mode" varchar(32) NOT NULL, "source" varchar(32) NOT NULL DEFAULT ('none'), "event" varchar(16) NOT NULL, "outcome" varchar(16) NOT NULL, "blockedBy" varchar(32) NOT NULL DEFAULT ('none'), "runtimeMs" integer NOT NULL DEFAULT (0), "timeSavedMin" integer NOT NULL DEFAULT (0), "origin" varchar(8) NOT NULL, "eventId" varchar NOT NULL, CONSTRAINT "CHK_execution_ledger_started_outcome" CHECK (("event" = 'started' AND "outcome" = 'none') OR ("event" = 'ended' AND "outcome" <> 'none')), CONSTRAINT "CHK_execution_ledger_blocked_reason" CHECK (("outcome" = 'blocked' AND "blockedBy" <> 'none') OR ("outcome" <> 'blocked' AND "blockedBy" = 'none')), CONSTRAINT "CHK_execution_ledger_entityType" CHECK ("entityType" IN ('workflow', 'agent')), CONSTRAINT "CHK_execution_ledger_event" CHECK ("event" IN ('started', 'ended')), CONSTRAINT "CHK_execution_ledger_outcome" CHECK ("outcome" IN ('none', 'success', 'error', 'crashed', 'canceled', 'blocked')), CONSTRAINT "CHK_execution_ledger_blockedBy" CHECK ("blockedBy" IN ('none', 'policy', 'credentialAccess', 'invalidWorkflow', 'contextHook', 'startFailed')), CONSTRAINT "CHK_execution_ledger_origin" CHECK ("origin" IN ('v1', 'v2')))

Name	Type	Default	Nullable	Children	Parents	Comment
blockedBy	varchar(32)	‘none’	false
entityId	varchar(36)		false
entityName	varchar(128)		false
entityType	varchar(16)		false
event	varchar(16)		false
eventId	varchar		false
executionId	varchar(36)		false
id	INTEGER		false
mode	varchar(32)		false
occurredAt	datetime(3)		false
origin	varchar(8)		false
outcome	varchar(16)		false
projectId	varchar(36)		false
runtimeMs	INTEGER	0	false
source	varchar(32)	‘none’	false
timeSavedMin	INTEGER	0	false

Name	Type	Definition
-	CHECK	CHECK ((“event” = ‘started’ AND “outcome” = ‘none’) OR (“event” = ‘ended’ AND “outcome” <> ‘none’))
-	CHECK	CHECK ((“outcome” = ‘blocked’ AND “blockedBy” <> ‘none’) OR (“outcome” <> ‘blocked’ AND “blockedBy” = ‘none’))
-	CHECK	CHECK (“entityType” IN (‘workflow’, ‘agent’))
-	CHECK	CHECK (“event” IN (‘started’, ‘ended’))
-	CHECK	CHECK (“outcome” IN (‘none’, ‘success’, ‘error’, ‘crashed’, ‘canceled’, ‘blocked’))
-	CHECK	CHECK (“blockedBy” IN (‘none’, ‘policy’, ‘credentialAccess’, ‘invalidWorkflow’, ‘contextHook’, ‘startFailed’))
-	CHECK	CHECK (“origin” IN (‘v1’, ‘v2’))
id	PRIMARY KEY	PRIMARY KEY (id)

erDiagram


"execution_ledger" {
  varchar_32_ blockedBy
  varchar_36_ entityId
  varchar_128_ entityName
  varchar_16_ entityType
  varchar_16_ event
  varchar eventId
  varchar_36_ executionId
  INTEGER id
  varchar_32_ mode
  datetime_3_ occurredAt
  varchar_8_ origin
  varchar_16_ outcome
  varchar_36_ projectId
  INTEGER runtimeMs
  varchar_32_ source
  INTEGER timeSavedMin
}