public.user_group_club¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| user_group_id | uuid | false | public.user_group | Unique identifier of the user group.(DC2Type:uuid) | ||
| club_id | uuid | false | public.club | Unique identifier for the club(DC2Type:uuid) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_36d3a5ee61190a32 | FOREIGN KEY | FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE |
| fk_36d3a5ee1ed93d47 | FOREIGN KEY | FOREIGN KEY (user_group_id) REFERENCES user_group(id) ON DELETE CASCADE |
| user_group_club_pkey | PRIMARY KEY | PRIMARY KEY (user_group_id, club_id) |
Indexes¶
| Name | Definition |
|---|---|
| user_group_club_pkey | CREATE UNIQUE INDEX user_group_club_pkey ON public.user_group_club USING btree (user_group_id, club_id) |
| idx_36d3a5ee1ed93d47 | CREATE INDEX idx_36d3a5ee1ed93d47 ON public.user_group_club USING btree (user_group_id) |
| idx_36d3a5ee61190a32 | CREATE INDEX idx_36d3a5ee61190a32 ON public.user_group_club USING btree (club_id) |
Relations¶
Generated by tbls