# public.self_healing_result ## Columns | Name | Type | Default | Nullable | Children | Parents | Comment | | ---- | ---- | ------- | -------- | -------- | ------- | ------- | | backgroundUserId | uuid | | false | | [public.user](public.user.md) | 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](public.user.md) | 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](public.project.md) | Original workflow owner project | | report | text | | false | | | Saved report, independent of execution and chat data | | suggestionId | varchar(36) | | true | | [public.workflow_suggestion](public.workflow_suggestion.md) | 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](public.workflow_entity.md) | 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 ```mermaid 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](https://github.com/k1LoW/tbls)