public.training_schedule¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | public.training_time | Unique identifier of the training schedule.(DC2Type:uuid) | ||
| club_id | uuid | false | public.club | Club where this training schedule is active.(DC2Type:uuid) | ||
| coach_id | uuid | false | public.coach | Coach who conducts training sessions according to this schedule.(DC2Type:uuid) | ||
| contentful_id | varchar(64) | false | Reference ID from Contentful CMS for syncing schedule data. | |||
| training_time_as_json | json | false | Deprecated JSON representation of training times. Use trainingTimes relation instead. | |||
| is_visible | boolean | true | false | Whether this training schedule is visible to users. |
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