public.court¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | public.court_image public.game public.match_series public.court_blocker_court | (DC2Type:uuid) | ||
| name | varchar(255) | false | ||||
| club_id | uuid | true | public.club | (DC2Type:uuid) | ||
| location_type | varchar(255) | false | ||||
| match_type | varchar(255) | true | ||||
| contentful_id | varchar(64) | false | ||||
| is_active | boolean | false | false | |||
| sport_id | uuid | false | public.sport | (DC2Type:uuid) | ||
| is_premium | boolean | false | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_63ae193f61190a32 | FOREIGN KEY | FOREIGN KEY (club_id) REFERENCES club(id) ON DELETE CASCADE |
| court_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| fk_63ae193fac78bcf8 | FOREIGN KEY | FOREIGN KEY (sport_id) REFERENCES sport(id) |
Indexes¶
| Name | Definition |
|---|---|
| court_pkey | CREATE UNIQUE INDEX court_pkey ON public.court USING btree (id) |
| idx_63ae193f61190a32 | CREATE INDEX idx_63ae193f61190a32 ON public.court USING btree (club_id) |
| uniq_63ae193fd756ce8c | CREATE UNIQUE INDEX uniq_63ae193fd756ce8c ON public.court USING btree (contentful_id) |
| idx_63ae193fac78bcf8 | CREATE INDEX idx_63ae193fac78bcf8 ON public.court USING btree (sport_id) |
Relations¶
Generated by tbls