public.self_healing_configuration_reviewer

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
configurationId	integer		false		public.self_healing_configuration
userId	uuid		false		public.user

Constraints

Name	Type	Definition
FK_75fdd60d4d2a7d8129107853a51	FOREIGN KEY	FOREIGN KEY ("configurationId") REFERENCES self_healing_configuration(id) ON DELETE CASCADE
FK_e87386774ef62c6aac38fd3e99b	FOREIGN KEY	FOREIGN KEY ("userId") REFERENCES "user"(id) ON DELETE CASCADE
PK_c986489025d4299c71802ee4b86	PRIMARY KEY	PRIMARY KEY ("configurationId", "userId")
self_healing_configuration_reviewer_configurationId_not_null	n	NOT NULL "configurationId"
self_healing_configuration_reviewer_userId_not_null	n	NOT NULL "userId"

Indexes

Name	Definition
IDX_e87386774ef62c6aac38fd3e99	CREATE INDEX "IDX_e87386774ef62c6aac38fd3e99" ON public.self_healing_configuration_reviewer USING btree ("userId")
PK_c986489025d4299c71802ee4b86	CREATE UNIQUE INDEX "PK_c986489025d4299c71802ee4b86" ON public.self_healing_configuration_reviewer USING btree ("configurationId", "userId")

Relations

erDiagram

"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_reviewer" }o--|| "public.user" : "FOREIGN KEY (#quot;userId#quot;) REFERENCES #quot;user#quot;(id) ON DELETE CASCADE"

"public.self_healing_configuration_reviewer" {
  integer configurationId FK
  uuid userId FK
}
"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
}

---

Generated by tbls