mirror of https://github.com/n8n-io/n8n.git synced 2026-07-28 11:35:03 +02:00

feat(core): Add sizeBytes and workflowVersionId to executions (no-changelog) (#32067 )

Co-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Co-authored-by: Iván Ovejero <ivov.src@gmail.com>

2026-06-12 09:44:19 +00:00

12 KiB

Raw Permalink Blame History

public.workflow_entity

Columns

Name	Type	Default	Nullable	Children	Parents
name	varchar(128)		false
active	boolean		false
nodes	json		false
connections	json		false
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
settings	json		true
staticData	json		true
pinData	json		true
versionId	character(36)		false
triggerCount	integer	0	false
id	varchar(36)		false	public.execution_entity public.webhook_entity public.workflows_tags public.workflow_history public.shared_workflow public.processed_data public.insights_metadata public.test_run public.chat_hub_sessions public.chat_hub_messages public.workflow_dependency public.workflow_publish_history public.workflow_published_version public.workflow_builder_session public.ai_builder_temporary_workflow public.evaluation_config public.evaluation_collection
meta	json		true
parentFolderId	varchar(36)	NULL::character varying	true		public.folder
isArchived	boolean	false	false
versionCounter	integer	1	false
description	text		true
activeVersionId	varchar(36)		true		public.workflow_history
nodeGroups	json	'[]'::json	false
sourceWorkflowId	varchar		true

Constraints

Name	Type	Definition
workflow_entity_active_not_null	n	NOT NULL active
workflow_entity_connections_not_null	n	NOT NULL connections
workflow_entity_createdAt_not_null	n	NOT NULL "createdAt"
workflow_entity_id_not_null1	n	NOT NULL id
workflow_entity_isArchived_not_null	n	NOT NULL "isArchived"
workflow_entity_name_not_null	n	NOT NULL name
workflow_entity_nodeGroups_not_null	n	NOT NULL "nodeGroups"
workflow_entity_nodes_not_null	n	NOT NULL nodes
workflow_entity_triggerCount_not_null	n	NOT NULL "triggerCount"
workflow_entity_updatedAt_not_null	n	NOT NULL "updatedAt"
workflow_entity_versionCounter_not_null	n	NOT NULL "versionCounter"
workflow_entity_versionId_not_null	n	NOT NULL "versionId"
workflow_entity_pkey	PRIMARY KEY	PRIMARY KEY (id)
FK_08d6c67b7f722b0039d9d5ed620	FOREIGN KEY	FOREIGN KEY ("activeVersionId") REFERENCES workflow_history("versionId") ON DELETE RESTRICT
fk_workflow_parent_folder	FOREIGN KEY	FOREIGN KEY ("parentFolderId") REFERENCES folder(id) ON DELETE CASCADE

Indexes

Name	Definition
pk_workflow_entity_id	CREATE UNIQUE INDEX pk_workflow_entity_id ON public.workflow_entity USING btree (id)
workflow_entity_pkey	CREATE UNIQUE INDEX workflow_entity_pkey ON public.workflow_entity USING btree (id)
IDX_workflow_entity_name	CREATE INDEX "IDX_workflow_entity_name" ON public.workflow_entity USING btree (name)
IDX_workflow_entity_sourceWorkflowId	CREATE INDEX "IDX_workflow_entity_sourceWorkflowId" ON public.workflow_entity USING btree ("sourceWorkflowId") WHERE ("sourceWorkflowId" IS NOT NULL)

Triggers

Name	Definition
workflow_version_increment	CREATE TRIGGER workflow_version_increment BEFORE UPDATE ON public.workflow_entity FOR EACH ROW EXECUTE FUNCTION increment_workflow_version()

Relations

erDiagram

"public.execution_entity" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.webhook_entity" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.workflows_tags" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.workflow_history" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.shared_workflow" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.processed_data" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.insights_metadata" }o--o| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE SET NULL"
"public.test_run" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.chat_hub_sessions" }o--o| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE SET NULL"
"public.chat_hub_messages" }o--o| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE SET NULL"
"public.workflow_dependency" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.workflow_publish_history" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.workflow_published_version" |o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE RESTRICT"
"public.workflow_builder_session" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.ai_builder_temporary_workflow" |o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.evaluation_config" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.evaluation_collection" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.workflow_entity" }o--o| "public.folder" : "FOREIGN KEY (#quot;parentFolderId#quot;) REFERENCES folder(id) ON DELETE CASCADE"
"public.workflow_entity" }o--o| "public.workflow_history" : "FOREIGN KEY (#quot;activeVersionId#quot;) REFERENCES workflow_history(#quot;versionId#quot;) ON DELETE RESTRICT"

"public.workflow_entity" {
  varchar_128_ name
  boolean active
  json nodes
  json connections
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
  json settings
  json staticData
  json pinData
  character_36_ versionId
  integer triggerCount
  varchar_36_ id
  json meta
  varchar_36_ parentFolderId FK
  boolean isArchived
  integer versionCounter
  text description
  varchar_36_ activeVersionId FK
  json nodeGroups
  varchar sourceWorkflowId
}
"public.execution_entity" {
  integer id
  boolean finished
  varchar mode
  varchar retryOf
  varchar retrySuccessId
  timestamp_3__with_time_zone startedAt
  timestamp_3__with_time_zone stoppedAt
  timestamp_3__with_time_zone waitTill
  varchar status
  varchar_36_ workflowId FK
  timestamp_3__with_time_zone deletedAt
  timestamp_3__with_time_zone createdAt
  varchar_2_ storedAt
  json tracingContext
  varchar_255_ deduplicationKey
  bigint jsonSizeBytes
  varchar_36_ workflowVersionId
}
"public.webhook_entity" {
  varchar webhookPath
  varchar method
  varchar node
  varchar webhookId
  integer pathLength
  varchar_36_ workflowId FK
}
"public.workflows_tags" {
  varchar_36_ workflowId FK
  varchar_36_ tagId FK
}
"public.workflow_history" {
  varchar_36_ versionId
  varchar_36_ workflowId FK
  varchar_255_ authors
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
  json nodes
  json connections
  varchar_128_ name
  boolean autosaved
  text description
  json nodeGroups
}
"public.shared_workflow" {
  varchar_36_ workflowId FK
  varchar_36_ projectId FK
  text role
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
}
"public.processed_data" {
  varchar_36_ workflowId FK
  varchar_255_ context
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
  text value
}
"public.insights_metadata" {
  integer metaId
  varchar_36_ workflowId FK
  varchar_36_ projectId FK
  varchar_128_ workflowName
  varchar_255_ projectName
}
"public.test_run" {
  varchar_36_ id
  varchar_36_ workflowId FK
  varchar status
  varchar errorCode
  json errorDetails
  timestamp_3__with_time_zone runAt
  timestamp_3__with_time_zone completedAt
  json metrics
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
  varchar_255_ runningInstanceId
  boolean cancelRequested
  varchar_36_ workflowVersionId
  varchar_36_ evaluationConfigId FK
  jsonb evaluationConfigSnapshot
  varchar_36_ collectionId FK
}
"public.chat_hub_sessions" {
  uuid id
  varchar_256_ title
  uuid ownerId FK
  timestamp_3__with_time_zone lastMessageAt
  varchar_36_ credentialId FK
  varchar_16_ provider
  varchar_256_ model
  varchar_36_ workflowId FK
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
  uuid agentId FK
  varchar_128_ agentName
  varchar_16_ type
}
"public.chat_hub_messages" {
  uuid id
  uuid sessionId FK
  uuid previousMessageId FK
  uuid revisionOfMessageId FK
  uuid retryOfMessageId FK
  varchar_16_ type
  varchar_128_ name
  text content
  varchar_16_ provider
  varchar_256_ model
  varchar_36_ workflowId FK
  integer executionId FK
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
  uuid agentId FK
  varchar_16_ status
  json attachments
}
"public.workflow_dependency" {
  integer id
  varchar_36_ workflowId FK
  integer workflowVersionId
  varchar_32_ dependencyType
  varchar_255_ dependencyKey
  json dependencyInfo
  smallint indexVersionId
  timestamp_3__with_time_zone createdAt
  varchar_36_ publishedVersionId
}
"public.workflow_publish_history" {
  integer id
  varchar_36_ workflowId FK
  varchar_36_ versionId FK
  varchar_36_ event
  uuid userId FK
  timestamp_3__with_time_zone createdAt
}
"public.workflow_published_version" {
  varchar_36_ workflowId FK
  varchar_36_ publishedVersionId FK
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
}
"public.workflow_builder_session" {
  uuid id
  varchar_36_ workflowId FK
  uuid userId FK
  json messages
  text previousSummary
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
  varchar_255_ activeVersionCardId
  varchar_255_ resumeAfterRestoreMessageId
}
"public.ai_builder_temporary_workflow" {
  varchar_36_ workflowId FK
  uuid threadId FK
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
}
"public.evaluation_config" {
  varchar_36_ id
  varchar_36_ workflowId FK
  varchar_128_ name
  varchar_16_ status
  varchar_64_ invalidReason
  varchar_32_ datasetSource
  json datasetRef
  varchar_255_ startNodeName
  varchar_255_ endNodeName
  json metrics
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
}
"public.evaluation_collection" {
  varchar_36_ id
  varchar_128_ name
  text description
  varchar_36_ workflowId FK
  varchar_36_ evaluationConfigId FK
  uuid createdById FK
  json insightsCache
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
}
"public.folder" {
  varchar_36_ id
  varchar_128_ name
  varchar_36_ parentFolderId FK
  varchar_36_ projectId FK
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone updatedAt
}

Generated by tbls

12 KiB Raw Permalink Blame History

public.workflow_entity

Columns

Constraints

Indexes

Triggers

Relations

12 KiB

Raw Permalink Blame History