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

public.self_healing_result

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
backgroundUserId	uuid		false		public.user	User who enabled the investigation
completedAt	timestamp(3) with time zone		false
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
dismissedAt	timestamp(3) with time zone		true
dismissedById	uuid		true		public.user	Reviewer who dismissed the result
executionId	varchar(36)		false			Execution reference retained after pruning; also supports the external v2 data plane
id	varchar(36)		false
outcome	varchar(16)		false			Accepted investigation outcome, separate from review closure
projectId	varchar(36)		false		public.project	Original workflow owner project
report	text		false			Saved report, independent of execution and chat data
suggestionId	varchar(36)		true		public.workflow_suggestion	Optional isolated workflow suggestion
summary	text		false
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
usage	json		false			Recorded runtime and accounting usage; null measurements mean unknown
workflowId	varchar(36)		false		public.workflow_entity	Investigated workflow

Constraints

Name	Type	Definition
CHK_self_healing_result_outcome	CHECK	CHECK (((outcome)::text = ANY ((ARRAY['fix_ready'::character varying, 'needs_you'::character varying, 'could_not_fix'::character varying])::text[])))
FK_3cb48b62bf261b7a6da666fee2d	FOREIGN KEY	FOREIGN KEY ("projectId") REFERENCES project(id) ON DELETE CASCADE
FK_738c3c0198c5ad104645a14fdc1	FOREIGN KEY	FOREIGN KEY ("suggestionId") REFERENCES workflow_suggestion(id) ON DELETE CASCADE
FK_8366669b58b0f63a07cf2bbffcc	FOREIGN KEY	FOREIGN KEY ("backgroundUserId") REFERENCES "user"(id) ON DELETE CASCADE
FK_98095dea3ff814d4ee37a1380e6	FOREIGN KEY	FOREIGN KEY ("dismissedById") REFERENCES "user"(id) ON DELETE SET NULL
FK_9a3fe8a8f872917949d8de1bb4a	FOREIGN KEY	FOREIGN KEY ("workflowId") REFERENCES workflow_entity(id) ON DELETE CASCADE
PK_0a772d117fddff1eaf6a759e1b6	PRIMARY KEY	PRIMARY KEY (id)
self_healing_result_backgroundUserId_not_null	n	NOT NULL "backgroundUserId"
self_healing_result_completedAt_not_null	n	NOT NULL "completedAt"
self_healing_result_createdAt_not_null	n	NOT NULL "createdAt"
self_healing_result_executionId_not_null	n	NOT NULL "executionId"
self_healing_result_id_not_null	n	NOT NULL id
self_healing_result_outcome_not_null	n	NOT NULL outcome
self_healing_result_projectId_not_null	n	NOT NULL "projectId"
self_healing_result_report_not_null	n	NOT NULL report
self_healing_result_summary_not_null	n	NOT NULL summary
self_healing_result_updatedAt_not_null	n	NOT NULL "updatedAt"
self_healing_result_usage_not_null	n	NOT NULL usage
self_healing_result_workflowId_not_null	n	NOT NULL "workflowId"

Indexes

Name	Definition
IDX_3cb48b62bf261b7a6da666fee2	CREATE INDEX "IDX_3cb48b62bf261b7a6da666fee2" ON public.self_healing_result USING btree ("projectId")
IDX_8366669b58b0f63a07cf2bbffc	CREATE INDEX "IDX_8366669b58b0f63a07cf2bbffc" ON public.self_healing_result USING btree ("backgroundUserId")
IDX_98095dea3ff814d4ee37a1380e	CREATE INDEX "IDX_98095dea3ff814d4ee37a1380e" ON public.self_healing_result USING btree ("dismissedById")
IDX_9a3fe8a8f872917949d8de1bb4	CREATE INDEX "IDX_9a3fe8a8f872917949d8de1bb4" ON public.self_healing_result USING btree ("workflowId")
IDX_self_healing_result_suggestionId	CREATE UNIQUE INDEX "IDX_self_healing_result_suggestionId" ON public.self_healing_result USING btree ("suggestionId") WHERE ("suggestionId" IS NOT NULL)
PK_0a772d117fddff1eaf6a759e1b6	CREATE UNIQUE INDEX "PK_0a772d117fddff1eaf6a759e1b6" ON public.self_healing_result USING btree (id)

Relations

erDiagram

"public.self_healing_result" }o--|| "public.user" : "FOREIGN KEY (#quot;backgroundUserId#quot;) REFERENCES #quot;user#quot;(id) ON DELETE CASCADE"
"public.self_healing_result" }o--o| "public.user" : "FOREIGN KEY (#quot;dismissedById#quot;) REFERENCES #quot;user#quot;(id) ON DELETE SET NULL"
"public.self_healing_result" }o--|| "public.project" : "FOREIGN KEY (#quot;projectId#quot;) REFERENCES project(id) ON DELETE CASCADE"
"public.self_healing_result" }o--o| "public.workflow_suggestion" : "FOREIGN KEY (#quot;suggestionId#quot;) REFERENCES workflow_suggestion(id) ON DELETE CASCADE"
"public.self_healing_result" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"

"public.self_healing_result" {
  uuid backgroundUserId FK
  timestamp_3__with_time_zone completedAt
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone dismissedAt
  uuid dismissedById FK
  varchar_36_ executionId
  varchar_36_ id
  varchar_16_ outcome
  varchar_36_ projectId FK
  text report
  varchar_36_ suggestionId FK
  text summary
  timestamp_3__with_time_zone updatedAt
  json usage
  varchar_36_ workflowId FK
}
"public.user" {
  timestamp_3__with_time_zone createdAt
  boolean disabled
  varchar_255_ email
  varchar_32_ firstName
  uuid id
  date lastActiveAt
  varchar_32_ lastName
  boolean mfaEnabled
  text mfaRecoveryCodes
  text mfaSecret
  varchar_255_ password
  json personalizationAnswers
  varchar_128_ roleSlug FK
  json settings
  timestamp_3__with_time_zone updatedAt
}
"public.project" {
  timestamp_3__with_time_zone createdAt
  uuid creatorId FK
  json customTelemetryTags
  varchar_512_ description
  json icon
  varchar_36_ id
  varchar_255_ name
  varchar_36_ type
  timestamp_3__with_time_zone updatedAt
}
"public.workflow_suggestion" {
  varchar_32_ appliedAction
  uuid appliedActorId
  varchar_64_ appliedChecksum
  varchar_36_ appliedVersionId
  uuid backgroundUserId FK
  timestamp_3__with_time_zone closedAt
  varchar_16_ closedReason
  timestamp_3__with_time_zone createdAt
  json expectedBaseline
  varchar_36_ id
  json payload
  varchar_36_ projectId FK
  varchar_16_ resultKind
  varchar_16_ state
  timestamp_3__with_time_zone updatedAt
  varchar_36_ workflowId FK
}
"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