Award Calendar

Live Asia Miles dates · CX metal

Data model

Entity-relationship diagram

Conceptual schema for Award Calendar. Live rows come from Cathay’s public calendar and timetable. Saved legs stay in the browser — there is no account table.

Primary keyForeign keyEntity

Search

Request
  • id
  • start_date
  • day_count
  • pax
  • fetched_at

SearchAirport

Junction
  • search_id
  • airport_code
  • role origin|dest

Airport

Reference
  • code
  • city
  • name

CityAlias

Reference
  • code
  • airport_code

AwardDay

CX calendar
  • origin
  • dest
  • date
  • first H|L|NA
  • business H|L|NA
  • prem_econ H|L|NA
  • economy H|L|NA

Flight

CX timetable
  • id
  • origin
  • dest
  • date
  • flight_no
  • operating
  • dep_time
  • arr_time
  • duration
  • stops
  • aircraft
  • via

SavedLeg

Browser
  • id
  • origin
  • dest
  • date

AwardTier

Chart
  • name
  • range
  • economy_miles
  • business_miles
  • first_miles

Relationships

  • Search1 : NSearchAirport

    a search lists up to 4 origins and 4 destinations

  • SearchAirportN : 1Airport

    each slot is one IATA code

  • CityAlias1 : NAirport

    TYO expands to NRT and HND

  • Airport1 : NAwardDay

    as origin and as destination

  • AwardDay1 : NFlight

    timetable flights that operate that date

  • AwardDay1 : 0..1SavedLeg

    optional pin stored in this browser

AwardDay.cabin flags are day-level (H / L / NA). Flight rows are the operating timetable for that date — not per-flight award inventory.