public.day_opening_time_override¶

Description¶

Name	Type	Default	Nullable	Parents	Comment
id	uuid		false		Unique identifier of the opening time override.(DC2Type:uuid)
club_id	uuid		false	public.club	Club for which this opening time override applies.(DC2Type:uuid)
created_at	timestamp(0) with time zone		false		Timestamp when this override was created.(DC2Type:datetimetz_immutable)
date	date		false		Specific date for which the opening hours are being overridden.(DC2Type:date_immutable)
opens_at	varchar(255)		false		Opening time for this date in HH:MM format.
closes_at	varchar(255)		false		Closing time for this date in HH:MM format (00:00 indicates next day midnight).
opened_hours	numeric(4,2)	NULL::numeric	true		Total hours the club is open on this date (calculated value).
is_opened	boolean		true		Whether the club is open on this date (false indicates closed for the day).

Name	Type	Definition
fk_a33654cf61190a32	FOREIGN KEY	FOREIGN KEY (club_id) REFERENCES club(id)
day_opening_time_override_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
day_opening_time_override_pkey	CREATE UNIQUE INDEX day_opening_time_override_pkey ON public.day_opening_time_override USING btree (id)
idx_a33654cf61190a32	CREATE INDEX idx_a33654cf61190a32 ON public.day_opening_time_override USING btree (club_id)
uniq_a33654cf61190a32aa9e377a	CREATE UNIQUE INDEX uniq_a33654cf61190a32aa9e377a ON public.day_opening_time_override USING btree (club_id, date)

Generated by tbls