public.user_favorites

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	integer		false
resourceId	varchar(255)		false
resourceType	varchar(64)		false
userId	uuid		false		public.user

Constraints

Name	Type	Definition
FK_1dd5c393ad0517be3c31a7af836	FOREIGN KEY	FOREIGN KEY ("userId") REFERENCES "user"(id) ON DELETE CASCADE
PK_6c472a19a7423cfbbf6b7c75939	PRIMARY KEY	PRIMARY KEY (id)
UQ_cf6ae658ead9ffc124723413c65	UNIQUE	UNIQUE ("userId", "resourceId", "resourceType")
user_favorites_id_not_null	n	NOT NULL id
user_favorites_resourceId_not_null	n	NOT NULL "resourceId"
user_favorites_resourceType_not_null	n	NOT NULL "resourceType"
user_favorites_userId_not_null	n	NOT NULL "userId"

Indexes

Name	Definition
IDX_1d11050a381548c42c32cc25c4	CREATE INDEX "IDX_1d11050a381548c42c32cc25c4" ON public.user_favorites USING btree ("resourceType", "resourceId")
IDX_1dd5c393ad0517be3c31a7af83	CREATE INDEX "IDX_1dd5c393ad0517be3c31a7af83" ON public.user_favorites USING btree ("userId")
PK_6c472a19a7423cfbbf6b7c75939	CREATE UNIQUE INDEX "PK_6c472a19a7423cfbbf6b7c75939" ON public.user_favorites USING btree (id)
UQ_cf6ae658ead9ffc124723413c65	CREATE UNIQUE INDEX "UQ_cf6ae658ead9ffc124723413c65" ON public.user_favorites USING btree ("userId", "resourceId", "resourceType")

Relations

erDiagram

"public.user_favorites" }o--|| "public.user" : "FOREIGN KEY (#quot;userId#quot;) REFERENCES #quot;user#quot;(id) ON DELETE CASCADE"

"public.user_favorites" {
  integer id
  varchar_255_ resourceId
  varchar_64_ resourceType
  uuid userId 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
}

---

Generated by tbls