public.opening_time¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | (DC2Type:uuid) | |||
| club_id | uuid | false | public.club | (DC2Type:uuid) | ||
| index | integer | true | ||||
| name | varchar(255) | false | ||||
| opens_at | varchar(255) | false | ||||
| closes_at | varchar(255) | false | ||||
| opened_hours | numeric(4,2) | false | ||||
| type | varchar(255) | NULL::character varying | false | |||
| is_opened | boolean | true |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_89115e6e61190a32 | FOREIGN KEY | FOREIGN KEY (club_id) REFERENCES club(id) |
| opening_time_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| opening_time_pkey | CREATE UNIQUE INDEX opening_time_pkey ON public.opening_time USING btree (id) |
| idx_89115e6e61190a32 | CREATE INDEX idx_89115e6e61190a32 ON public.opening_time USING btree (club_id) |
| uniq_89115e6e807367018cde572961190a32 | CREATE UNIQUE INDEX uniq_89115e6e807367018cde572961190a32 ON public.opening_time USING btree (index, type, club_id) |
Relations¶
Generated by tbls