airlines

airline_idnamecode
1UnitedUA
2DeltaDL
3SouthwestWN
4AmericanAA
5AlaskaAS

flights

flight_iddeparture_timearrival_timedistanceorigin_airport_codedestination_airport_codeairline_id
(→ airlines.airline_id)
12022-10-01 08:00:002022-10-01 10:00:002500.0ORDLAX1
22022-10-01 12:00:002022-10-01 14:00:003000.0JFKSEA2
32022-10-01 16:00:002022-10-01 18:00:002700.0DFWPHX3
42022-10-01 19:00:002022-10-01 21:00:002200.0MIAATL4
52022-10-01 22:00:002022-10-02 02:00:004500.0LAXHNL5

terminals

terminal_numbercapacitylocation
150Terminal A
260Terminal B
370Terminal C
445Terminal D
530Terminal E

boarding_areas

boarding_area_idterminal_numbergate
(→ terminals.terminal_number)
1110
2112
3214
4216
5318

flights_boarding_areas

flight_idboarding_area_id
(→ flights.flight_id)(→ boarding_areas.boarding_area_id)
11
23
32
44
55