public.training_schedule¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | public.training_time | (DC2Type:uuid) | ||
| club_id | uuid | false | public.club | (DC2Type:uuid) | ||
| coach_id | uuid | false | public.coach | (DC2Type:uuid) | ||
| contentful_id | varchar(64) | false | ||||
| training_time_as_json | json | false | ||||
| is_visible | boolean | true | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_bd5d026c61190a32 | FOREIGN KEY | FOREIGN KEY (club_id) REFERENCES club(id) |
| fk_bd5d026c3c105691 | FOREIGN KEY | FOREIGN KEY (coach_id) REFERENCES coach(id) |
| training_schedule_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| training_schedule_pkey | CREATE UNIQUE INDEX training_schedule_pkey ON public.training_schedule USING btree (id) |
| idx_bd5d026c3c105691 | CREATE INDEX idx_bd5d026c3c105691 ON public.training_schedule USING btree (coach_id) |
| idx_bd5d026c61190a32 | CREATE INDEX idx_bd5d026c61190a32 ON public.training_schedule USING btree (club_id) |
| uniq_bd5d026c61190a323c105691 | CREATE UNIQUE INDEX uniq_bd5d026c61190a323c105691 ON public.training_schedule USING btree (club_id, coach_id) |
| uniq_bd5d026cd756ce8c | CREATE UNIQUE INDEX uniq_bd5d026cd756ce8c ON public.training_schedule USING btree (contentful_id) |
Relations¶
Generated by tbls