airports

idnamecitycountryairport_facilitieslocation
1JFK InternationalNew YorkUSABaggage ClaimTerminal 2
2Heathrow AirportLondonUKSecurity CheckTerminal 3
3Charles de GaulleParisFranceBaggage ClaimTerminal 1
4Hong Kong InternationalHong KongChinaSecurity CheckTerminal 2
5Dubai InternationalDubaiUAEBaggage ClaimTerminal 1
6Tokyo HanedaTokyoJapanSecurity CheckTerminal 3

terminals

idairport_idterminal_number
(→ airports.id)
112
223
331
442
553

flights

idterminal_iddeparture_timearrival_timedestination_city
(→ terminals.id)
1108:00:0010:00:00Los Angeles
2209:00:0011:00:00Miami
3310:00:0012:00:00Toronto
4111:00:0013:00:00San Francisco
5212:00:0014:00:00Seattle

passengers

idfirst_namelast_nameageflight_id
(→ flights.id)
1JohnDoe301
2JaneSmith272
3AliceJohnson423
4BobWilliams654
5EmmaTaylor235
6MichaelAnderson356