| id |
uuid |
|
false |
|
|
Unique identifier for the opening time entry(DC2Type:uuid) |
| club_id |
uuid |
|
false |
|
public.club |
Reference to the club this opening time belongs to(DC2Type:uuid) |
| index |
integer |
|
true |
|
|
Day index for weekday entries (0-6, where 0=Monday), null for holidays |
| name |
varchar(255) |
|
false |
|
|
Display name for the opening time (e.g., "Monday", "Christmas Day") |
| opens_at |
varchar(255) |
|
false |
|
|
Opening time in HH:MM format (24-hour clock) |
| closes_at |
varchar(255) |
|
false |
|
|
Closing time in HH:MM format (24-hour clock, 00:00 means next day midnight) |
| opened_hours |
numeric(4,2) |
|
false |
|
|
Total hours the club is open during this time period (calculated value) |
| type |
varchar(255) |
NULL::character varying |
false |
|
|
Type of opening time entry: WEEKDAY for regular weekly schedule or HOLIDAY for special dates |
| is_opened |
boolean |
|
true |
|
|
Flag indicating whether the club is currently open during this time slot |
