public.self_healing_investigation
Columns
| Name |
Type |
Default |
Nullable |
Children |
Parents |
Comment |
| backgroundUserId |
uuid |
|
false |
|
public.user |
User who enabled the investigation |
| baseline |
json |
|
false |
|
|
Workflow snapshot and version checks captured at admission |
| configurationId |
integer |
|
false |
|
public.self_healing_configuration |
|
| createdAt |
timestamp(3) with time zone |
CURRENT_TIMESTAMP(3) |
false |
|
|
|
| executionId |
varchar(36) |
|
false |
|
|
Original execution reference retained after pruning; supports both execution engines |
| finishedAt |
timestamp(3) with time zone |
|
true |
|
|
When the investigation released its workflow claim |
| id |
varchar(36) |
|
false |
|
|
|
| projectId |
varchar(36) |
|
false |
|
public.project |
Workflow owner project at admission |
| resultId |
varchar(36) |
|
true |
|
public.self_healing_result |
Result saved by atomic investigation completion |
| runId |
uuid |
|
false |
|
|
Assistant run ID; technical status stays in run events |
| threadId |
uuid |
|
false |
|
|
Private Assistant thread ID; retained after deletion |
| updatedAt |
timestamp(3) with time zone |
CURRENT_TIMESTAMP(3) |
false |
|
|
|
| workflowId |
varchar(36) |
|
false |
|
public.workflow_entity |
Investigated workflow |
Constraints
| Name |
Type |
Definition |
| FK_24923f35caa34c1f264576a7914 |
FOREIGN KEY |
FOREIGN KEY ("backgroundUserId") REFERENCES "user"(id) ON DELETE CASCADE |
| FK_39a928c9ea7b7afce4bdd1c6dae |
FOREIGN KEY |
FOREIGN KEY ("resultId") REFERENCES self_healing_result(id) ON DELETE CASCADE |
| FK_7fa67c33c27bcc5d745c75a7eab |
FOREIGN KEY |
FOREIGN KEY ("workflowId") REFERENCES workflow_entity(id) ON DELETE CASCADE |
| FK_eb5b7d44599bd9a34f02f071b23 |
FOREIGN KEY |
FOREIGN KEY ("projectId") REFERENCES project(id) ON DELETE CASCADE |
| FK_self_healing_investigation_configuration |
FOREIGN KEY |
FOREIGN KEY ("configurationId") REFERENCES self_healing_configuration(id) ON DELETE CASCADE |
| PK_735895e1c137cd827884cfa843a |
PRIMARY KEY |
PRIMARY KEY (id) |
| self_healing_investigation_backgroundUserId_not_null |
n |
NOT NULL "backgroundUserId" |
| self_healing_investigation_baseline_not_null |
n |
NOT NULL baseline |
| self_healing_investigation_configurationId_not_null |
n |
NOT NULL "configurationId" |
| self_healing_investigation_createdAt_not_null |
n |
NOT NULL "createdAt" |
| self_healing_investigation_executionId_not_null |
n |
NOT NULL "executionId" |
| self_healing_investigation_id_not_null |
n |
NOT NULL id |
| self_healing_investigation_projectId_not_null |
n |
NOT NULL "projectId" |
| self_healing_investigation_runId_not_null |
n |
NOT NULL "runId" |
| self_healing_investigation_threadId_not_null |
n |
NOT NULL "threadId" |
| self_healing_investigation_updatedAt_not_null |
n |
NOT NULL "updatedAt" |
| self_healing_investigation_workflowId_not_null |
n |
NOT NULL "workflowId" |
Indexes
| Name |
Definition |
| IDX_24923f35caa34c1f264576a791 |
CREATE INDEX "IDX_24923f35caa34c1f264576a791" ON public.self_healing_investigation USING btree ("backgroundUserId") |
| IDX_bfdc789961ad0537486e0e2d29 |
CREATE UNIQUE INDEX "IDX_bfdc789961ad0537486e0e2d29" ON public.self_healing_investigation USING btree ("workflowId", "executionId") |
| IDX_eb5b7d44599bd9a34f02f071b2 |
CREATE INDEX "IDX_eb5b7d44599bd9a34f02f071b2" ON public.self_healing_investigation USING btree ("projectId") |
| IDX_self_healing_investigation_configurationId |
CREATE INDEX "IDX_self_healing_investigation_configurationId" ON public.self_healing_investigation USING btree ("configurationId") |
| IDX_self_healing_investigation_resultId |
CREATE UNIQUE INDEX "IDX_self_healing_investigation_resultId" ON public.self_healing_investigation USING btree ("resultId") WHERE ("resultId" IS NOT NULL) |
| IDX_self_healing_investigation_workflowId |
CREATE UNIQUE INDEX "IDX_self_healing_investigation_workflowId" ON public.self_healing_investigation USING btree ("workflowId") WHERE ("finishedAt" IS NULL) |
| PK_735895e1c137cd827884cfa843a |
CREATE UNIQUE INDEX "PK_735895e1c137cd827884cfa843a" ON public.self_healing_investigation USING btree (id) |
Relations
erDiagram
"public.self_healing_investigation" }o--|| "public.user" : "FOREIGN KEY (#quot;backgroundUserId#quot;) REFERENCES #quot;user#quot;(id) ON DELETE CASCADE"
"public.self_healing_investigation" }o--|| "public.self_healing_configuration" : "FOREIGN KEY (#quot;configurationId#quot;) REFERENCES self_healing_configuration(id) ON DELETE CASCADE"
"public.self_healing_investigation" }o--|| "public.project" : "FOREIGN KEY (#quot;projectId#quot;) REFERENCES project(id) ON DELETE CASCADE"
"public.self_healing_investigation" }o--o| "public.self_healing_result" : "FOREIGN KEY (#quot;resultId#quot;) REFERENCES self_healing_result(id) ON DELETE CASCADE"
"public.self_healing_investigation" }o--|| "public.workflow_entity" : "FOREIGN KEY (#quot;workflowId#quot;) REFERENCES workflow_entity(id) ON DELETE CASCADE"
"public.self_healing_investigation" {
uuid backgroundUserId FK
json baseline
integer configurationId FK
timestamp_3__with_time_zone createdAt
varchar_36_ executionId
timestamp_3__with_time_zone finishedAt
varchar_36_ id
varchar_36_ projectId FK
varchar_36_ resultId FK
uuid runId
uuid threadId
timestamp_3__with_time_zone updatedAt
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.self_healing_configuration" {
timestamp_3__with_time_zone createdAt
boolean enabled
uuid enabledById FK
integer id
varchar_36_ projectId FK
varchar_16_ scope
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.self_healing_result" {
uuid backgroundUserId FK
timestamp_3__with_time_zone completedAt
integer configurationId FK
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.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