Skip to content

public.liked_clubs

Description

Columns

Name Type Default Nullable Children Parents Comment
user_id uuid false public.user (DC2Type:uuid)
club_id uuid false public.club (DC2Type:uuid)

Constraints

Name Type Definition
fk_bb383fe561190a32 FOREIGN KEY FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE
liked_clubs_pkey PRIMARY KEY PRIMARY KEY (user_id, club_id)
fk_bb383fe5a76ed395 FOREIGN KEY FOREIGN KEY (user_id) REFERENCES "user"(id) ON DELETE CASCADE

Indexes

Name Definition
liked_clubs_pkey CREATE UNIQUE INDEX liked_clubs_pkey ON public.liked_clubs USING btree (user_id, club_id)
idx_bb383fe561190a32 CREATE INDEX idx_bb383fe561190a32 ON public.liked_clubs USING btree (club_id)
idx_bb383fe5a76ed395 CREATE INDEX idx_bb383fe5a76ed395 ON public.liked_clubs USING btree (user_id)

Relations

er

Generated by tbls