| id |
uuid |
|
false |
public.holiday_name |
|
Unique identifier for the holiday record(DC2Type:uuid) |
| created_at |
timestamp(0) with time zone |
|
false |
|
|
Timestamp when the holiday record was created(DC2Type:datetimetz_immutable) |
| start_date |
date |
|
false |
|
|
Start date of the holiday(DC2Type:date_immutable) |
| end_date |
date |
|
false |
|
|
End date of the holiday (for multi-day holidays)(DC2Type:date_immutable) |
| is_nationwide |
boolean |
|
false |
|
|
Whether the holiday applies to the entire country or only specific regions |
| open_holiday_id |
uuid |
|
false |
|
|
External identifier from the OpenHolidays API(DC2Type:uuid) |
| name |
varchar(255) |
|
false |
|
|
Default name of the holiday (fallback if no localized name is available) |
| country_iso_code |
varchar(10) |
|
false |
|
|
ISO country code where the holiday applies (e.g., DE, US, FR) |
| subdivisions |
text |
|
true |
|
|
Array of subdivision codes where the holiday applies (if not nationwide)(DC2Type:simple_array) |
