Airline

idnameheadquarters
1American AirlinesFort Worth
2Delta AirlinesAtlanta
3United AirlinesChicago
4Southwest AirlinesDallas
5JetBlue AirwaysNew York City

Terminal

idnumberlocationcapacity
11Terminal 130
22Terminal 260
33Terminal 380
44Terminal 470
55Terminal 590

Flight

idairlineIddepartureTimearrivalTimedestination
(→ Airline.id)
112022-01-01 08:00:002022-01-01 10:00:00Los Angeles
212022-01-02 08:00:002022-01-02 10:00:00San Francisco
322022-01-03 08:00:002022-01-03 10:00:00Miami
422022-01-04 08:00:002022-01-04 10:00:00Honolulu
532022-01-05 08:00:002022-01-05 10:00:00London

Passenger

idflightIdfirstNamelastNameagecountryOfResidence
(→ Flight.id)
11JohnSmith30USA
21JaneDoe25Canada
32AliceJohnson40UK
42BobWilliams50Australia
53EmmaBrown22Germany

Aircraft

idmodelcapacitycurrentFlightId
(→ Flight.id)
1Boeing 737200None
2Airbus A320180None
3Bombardier Q40080None
4Embraer E190100None
5De Havilland Dash 850None

Facility

idtypeterminalId
(→ Terminal.id)
1Baggage Claim2
2Baggage Claim3
3Security Check2
4Security Check4
5Restaurant1