n8n/docs/generated/sqlite-schema/execution_metadata.md

execution_metadata

Description

Table Definition

CREATE TABLE "execution_metadata" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "executionId" integer NOT NULL, "key" varchar(255) NOT NULL, "value" text NOT NULL, CONSTRAINT "FK_31d0b4c93fb85ced26f6005cda3" FOREIGN KEY ("executionId") REFERENCES "execution_entity" ("id") ON DELETE CASCADE)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	INTEGER		false
executionId	INTEGER		false		execution_entity
key	varchar(255)		false
value	TEXT		false

Constraints

Name	Type	Definition
id	PRIMARY KEY	PRIMARY KEY (id)
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (executionId) REFERENCES execution_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE

Indexes

Name	Definition
IDX_cec8eea3bf49551482ccb4933e	CREATE UNIQUE INDEX "IDX_cec8eea3bf49551482ccb4933e" ON "execution_metadata" ("executionId", "key")

Relations

erDiagram

"execution_metadata" }o--|| "execution_entity" : "FOREIGN KEY (executionId) REFERENCES execution_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"execution_metadata" {
  INTEGER id
  INTEGER executionId FK
  varchar_255_ key
  TEXT value
}
"execution_entity" {
  INTEGER id
  varchar_36_ workflowId FK
  boolean finished
  varchar mode
  varchar retryOf
  varchar retrySuccessId
  datetime startedAt
  datetime stoppedAt
  datetime waitTill
  varchar status
  datetime_3_ deletedAt
  datetime_3_ createdAt
  varchar_2_ storedAt
  TEXT tracingContext
  varchar_255_ deduplicationKey
  BIGINT jsonSizeBytes
  VARCHAR_36_ workflowVersionId
}

---

Generated by tbls