n8n/docs/generated/postgres-schema/public.workflow_dependency.md

public.workflow_dependency

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
dependencyInfo	json		true			Additional info about the dependency, interpreted based on type
dependencyKey	varchar(255)		false			ID or name of the dependency
dependencyType	varchar(32)		false			Type of dependency: "credential", "nodeType", "webhookPath", or "workflowCall"
id	integer		false
indexVersionId	smallint	1	false			Version of the index structure
publishedVersionId	varchar(36)		true
workflowId	varchar(36)		false		public.workflow_entity
workflowVersionId	integer		false			Version of the workflow

Constraints

Name	Type	Definition
FK_a4ff2d9b9628ea988fa9e7d0bf8	FOREIGN KEY	FOREIGN KEY ("workflowId") REFERENCES workflow_entity(id) ON DELETE CASCADE
PK_52325e34cd7a2f0f67b0f3cad65	PRIMARY KEY	PRIMARY KEY (id)
workflow_dependency_createdAt_not_null	n	NOT NULL "createdAt"
workflow_dependency_dependencyKey_not_null	n	NOT NULL "dependencyKey"
workflow_dependency_dependencyType_not_null	n	NOT NULL "dependencyType"
workflow_dependency_id_not_null	n	NOT NULL id
workflow_dependency_indexVersionId_not_null	n	NOT NULL "indexVersionId"
workflow_dependency_workflowId_not_null	n	NOT NULL "workflowId"
workflow_dependency_workflowVersionId_not_null	n	NOT NULL "workflowVersionId"

Indexes

Name	Definition
IDX_a4ff2d9b9628ea988fa9e7d0bf	CREATE INDEX "IDX_a4ff2d9b9628ea988fa9e7d0bf" ON public.workflow_dependency USING btree ("workflowId")
IDX_e48a201071ab85d9d09119d640	CREATE INDEX "IDX_e48a201071ab85d9d09119d640" ON public.workflow_dependency USING btree ("dependencyKey")
IDX_e7fe1cfda990c14a445937d0b9	CREATE INDEX "IDX_e7fe1cfda990c14a445937d0b9" ON public.workflow_dependency USING btree ("dependencyType")
IDX_workflow_dependency_publishedVersionId	CREATE INDEX "IDX_workflow_dependency_publishedVersionId" ON public.workflow_dependency USING btree ("publishedVersionId")
PK_52325e34cd7a2f0f67b0f3cad65	CREATE UNIQUE INDEX "PK_52325e34cd7a2f0f67b0f3cad65" ON public.workflow_dependency USING btree (id)

Relations

erDiagram

"public.workflow_dependency" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"

"public.workflow_dependency" {
  timestamp_3__with_time_zone createdAt
  json dependencyInfo
  varchar_255_ dependencyKey
  varchar_32_ dependencyType
  integer id
  smallint indexVersionId
  varchar_36_ publishedVersionId
  varchar_36_ workflowId FK
  integer workflowVersionId
}
"public.workflow_entity" {
  boolean active
  varchar_36_ activeVersionId FK
  json connections
  timestamp_3__with_time_zone createdAt
  text description
  varchar_36_ id
  boolean isArchived
  json meta
  varchar_128_ name
  json nodeGroups
  json nodes
  varchar_36_ parentFolderId FK
  json pinData
  json settings
  varchar sourceWorkflowId
  json staticData
  integer triggerCount
  timestamp_3__with_time_zone updatedAt
  integer versionCounter
  character_36_ versionId
}

---

Generated by tbls