public.club_image¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| club_id | uuid | false | public.club | Unique identifier for the club(DC2Type:uuid) | ||
| image_id | uuid | false | public.image | Unique identifier for the image record(DC2Type:uuid) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| club_image_pkey | PRIMARY KEY | PRIMARY KEY (club_id, image_id) |
| fk_65532eed61190a32 | FOREIGN KEY | FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE |
| fk_65532eed3da5256d | FOREIGN KEY | FOREIGN KEY (image_id) REFERENCES image(id) ON DELETE CASCADE |
Indexes¶
| Name | Definition |
|---|---|
| club_image_pkey | CREATE UNIQUE INDEX club_image_pkey ON public.club_image USING btree (club_id, image_id) |
| idx_65532eed3da5256d | CREATE INDEX idx_65532eed3da5256d ON public.club_image USING btree (image_id) |
| idx_65532eed61190a32 | CREATE INDEX idx_65532eed61190a32 ON public.club_image USING btree (club_id) |
Relations¶
Generated by tbls