public.self_healing_configuration

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
enabled	boolean	false	false
enabledById	uuid		true		public.user	User whose access authorizes future investigations
id	integer		false	public.self_healing_configuration_reviewer public.self_healing_configuration_workflow public.self_healing_investigation public.self_healing_result
projectId	varchar(36)		false		public.project
scope	varchar(16)		false			All project workflows or explicit selections
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
CHK_self_healing_configuration_scope	CHECK	CHECK (((scope)::text = ANY ((ARRAY['all'::character varying, 'selected'::character varying])::text[])))
FK_0a8f9425ffdc01cce5876bc6247	FOREIGN KEY	FOREIGN KEY ("projectId") REFERENCES project(id) ON DELETE CASCADE
FK_2b04620d7af4060ba89412123ea	FOREIGN KEY	FOREIGN KEY ("enabledById") REFERENCES "user"(id) ON DELETE SET NULL
PK_ffe1ae2a729e3035ddbdc5f22b6	PRIMARY KEY	PRIMARY KEY (id)
self_healing_configuration_createdAt_not_null	n	NOT NULL "createdAt"
self_healing_configuration_enabled_not_null	n	NOT NULL enabled
self_healing_configuration_id_not_null	n	NOT NULL id
self_healing_configuration_projectId_not_null	n	NOT NULL "projectId"
self_healing_configuration_scope_not_null	n	NOT NULL scope
self_healing_configuration_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
IDX_0a8f9425ffdc01cce5876bc624	CREATE INDEX "IDX_0a8f9425ffdc01cce5876bc624" ON public.self_healing_configuration USING btree ("projectId")
IDX_2b04620d7af4060ba89412123e	CREATE INDEX "IDX_2b04620d7af4060ba89412123e" ON public.self_healing_configuration USING btree ("enabledById")
IDX_self_healing_configuration_projectId	CREATE UNIQUE INDEX "IDX_self_healing_configuration_projectId" ON public.self_healing_configuration USING btree ("projectId") WHERE ((scope)::text = 'all'::text)
PK_ffe1ae2a729e3035ddbdc5f22b6	CREATE UNIQUE INDEX "PK_ffe1ae2a729e3035ddbdc5f22b6" ON public.self_healing_configuration USING btree (id)

Relations

erDiagram

"public.self_healing_configuration" }o--o| "public.user" : "FOREIGN KEY (#quot;enabledById#quot;) REFERENCES #quot;user#quot;(id) ON DELETE SET NULL"
"public.self_healing_configuration_reviewer" }o--|| "public.self_healing_configuration" : "FOREIGN KEY (#quot;configurationId#quot;) REFERENCES self_healing_configuration(id) ON DELETE CASCADE"
"public.self_healing_configuration_workflow" }o--|| "public.self_healing_configuration" : "FOREIGN KEY (#quot;configurationId#quot;) REFERENCES self_healing_configuration(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_result" }o--|| "public.self_healing_configuration" : "FOREIGN KEY (#quot;configurationId#quot;) REFERENCES self_healing_configuration(id) ON DELETE CASCADE"
"public.self_healing_configuration" }o--|| "public.project" : "FOREIGN KEY (#quot;projectId#quot;) REFERENCES project(id) ON DELETE CASCADE"

"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.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_reviewer" {
  integer configurationId FK
  uuid userId FK
}
"public.self_healing_configuration_workflow" {
  integer configurationId FK
  varchar_36_ projectId FK
  varchar_36_ workflowId FK
}
"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.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.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
}

---

Generated by tbls