public.coach_absence

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false			Unique identifier for the coach absence record.(DC2Type:uuid)
coach_id	uuid		false		public.coach	Reference to the coach who is absent. Required for all absence records.(DC2Type:uuid)
title	varchar(255)		false			Title or description of the absence reason (e.g., vacation, sick leave, training).
starts_at	timestamp(0) with time zone		false			Start date and time of the coach absence period (timezone-aware).(DC2Type:datetimetz_immutable)
ends_at	timestamp(0) with time zone		false			End date and time of the coach absence period (timezone-aware).(DC2Type:datetimetz_immutable)

Constraints

Name	Type	Definition
coach_absence_pkey	PRIMARY KEY	PRIMARY KEY (id)
fk_cd8a08813c105691	FOREIGN KEY	FOREIGN KEY (coach_id) REFERENCES coach(id)

Indexes

Name	Definition
coach_absence_pkey	CREATE UNIQUE INDEX coach_absence_pkey ON public.coach_absence USING btree (id)
idx_cd8a08813c105691	CREATE INDEX idx_cd8a08813c105691 ON public.coach_absence USING btree (coach_id)

Relations

---

Generated by tbls