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)