holi
Tables (4)
country
- id — BIGINT
- country_code — VARCHAR(4) — NOT NULL
- name — VARCHAR(255) — NOT NULL
holiday
- id (Key) — BIGINT — Primary key — NOT NULL
- date — DATE — NOT NULL
- local_name — VARCHAR(255) — NOT NULL
- english_name — VARCHAR(255) — NOT NULL
- country_code — VARCHAR(4) — NOT NULL
- fixed — BOOLEAN
- global_holiday — BOOLEAN
- launch_year — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
holiday_counties
- holiday_id (Key) — BIGINT — Foreign key → holiday.id — NOT NULL
- county_code — VARCHAR(255)
holiday_types
- holiday_id (Key) — BIGINT — Foreign key → holiday.id — NOT NULL
- type_name — VARCHAR(255)