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

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

CREATE TABLE "workflow_entity" ("id" varchar(36) PRIMARY KEY NOT NULL, "name" varchar(128) NOT NULL, "active" boolean NOT NULL, "nodes" text, "connections" text, "settings" text, "staticData" text, "pinData" text, "versionId" varchar(36) NOT NULL, "triggerCount" integer DEFAULT (0), "meta" text, "parentFolderId" varchar(36), "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')), "isArchived" boolean NOT NULL DEFAULT (FALSE), "versionCounter" integer NOT NULL DEFAULT (1), "description" text, "activeVersionId" varchar(36), "nodeGroups" text NOT NULL DEFAULT ('[]'), "sourceWorkflowId" varchar, CONSTRAINT "FK_04a4db5906fbc5606c71448d912" FOREIGN KEY ("parentFolderId") REFERENCES "folder" ("id") ON DELETE CASCADE ON UPDATE NO ACTION, CONSTRAINT "FK_08d6c67b7f722b0039d9d5ed620" FOREIGN KEY ("activeVersionId") REFERENCES "workflow_history" ("versionId") ON DELETE RESTRICT ON UPDATE NO ACTION)

Name	Type	Default	Nullable	Children	Parents	Comment
active	boolean		false
activeVersionId	varchar(36)		true		workflow_history
connections	TEXT		true
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
description	TEXT		true
id	varchar(36)		false	agent_workflow_dependency ai_builder_temporary_workflow chat_hub_messages chat_hub_sessions evaluation_collection evaluation_config execution_entity insights_metadata migration_finding migration_workflow_owner poller_state processed_data self_healing_configuration_workflow self_healing_investigation self_healing_result shared_workflow test_run workflow_builder_session workflow_dependency workflow_history workflow_publication_retry_state workflow_publication_trigger_status workflow_publish_history workflow_published_version workflow_review_request_workflow workflow_suggestion workflows_tags
isArchived	boolean	FALSE	false
meta	TEXT		true
name	varchar(128)		false
nodeGroups	TEXT	‘[]’	false
nodes	TEXT		true
parentFolderId	varchar(36)		true		folder
pinData	TEXT		true
settings	TEXT		true
sourceWorkflowId	varchar		true
staticData	TEXT		true
triggerCount	INTEGER	0	true
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
versionCounter	INTEGER	1	false
versionId	varchar(36)		false

Name	Type	Definition
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (activeVersionId) REFERENCES workflow_history (versionId) ON UPDATE NO ACTION ON DELETE RESTRICT MATCH NONE
- (Foreign key ID: 1)	FOREIGN KEY	FOREIGN KEY (parentFolderId) REFERENCES folder (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_workflow_entity_1	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
IDX_e10425f6ab9964c4c1623a4a03	CREATE INDEX “IDX_e10425f6ab9964c4c1623a4a03” ON “workflow_entity” (“name”)
IDX_workflow_entity_sourceWorkflowId	CREATE INDEX “IDX_workflow_entity_sourceWorkflowId” ON “workflow_entity” (“sourceWorkflowId”) WHERE “sourceWorkflowId” IS NOT NULL
sqlite_autoindex_workflow_entity_1	PRIMARY KEY (id)

Name	Definition
workflow_version_increment	CREATE TRIGGER “workflow_version_increment” AFTER UPDATE ON “workflow_entity” FOR EACH ROW WHEN OLD.”versionCounter” = NEW.”versionCounter” AND (OLD.”nodes” IS NOT NEW.”nodes” OR OLD.”settings” IS NOT NEW.”settings”) BEGIN UPDATE “workflow_entity” SET “versionCounter” = “versionCounter” + 1 WHERE “id” = NEW.”id”; END

erDiagram

"workflow_entity" }o--o| "workflow_history" : "FOREIGN KEY (activeVersionId) REFERENCES workflow_history (versionId) ON UPDATE NO ACTION ON DELETE RESTRICT MATCH NONE"
"agent_workflow_dependency" |o--|| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"ai_builder_temporary_workflow" |o--|| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"chat_hub_messages" }o--o| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"chat_hub_sessions" }o--o| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"evaluation_collection" }o--|| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"evaluation_config" }o--|| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"execution_entity" }o--|| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"insights_metadata" }o--o| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"migration_finding" }o--|| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"migration_workflow_owner" |o--|| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"poller_state" |o--|| "workflow_entity" : "FOREIGN KEY (workflowId) REFERENCES workflow_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"