Airport

idnamecitycountry
1San Francisco InternationalSan FranciscoUSA
2London HeathrowLondonUK
3Dubai InternationalDubaiUAE
4Tokyo HanedaTokyoJapan
5New York JFKNew YorkUSA

Terminal

idnumbercapacityairportId
(→ Airport.id)
11301
22281
31272
42262
51253

Gate

idgateNumberterminalId
(→ Terminal.id)
111
221
332
442
551

Flight

idflightNumberairlineNamedepartureTimearrivalTimeoriginAirportIddestinationAirportIdgateId
(→ Airport.id)(→ Airport.id)(→ Gate.id)
1AA101American Airlines2022-12-10 09:00:002022-12-10 12:00:00121
2BA202British Airways2022-12-11 11:00:002022-12-11 15:00:00232
3EK310Emirates2022-12-12 08:00:002022-12-12 14:00:00343
4UA888United Airlines2022-12-13 09:00:002022-12-13 12:00:00124
5NH100All Nippon Airways2022-12-14 11:00:002022-12-14 15:00:00415

FlightOperation

idoperationTypedetailsfacilitiesflightId
(→ Flight.id)
1DepartureCheck-in counters open at 6amLounge Access1
2DepartureSecurity checkpoint opens at 5:30amFree WiFi2
3ArrivalCustoms and immigration hall open at 6amLounge Access3
4ArrivalBaggage claim area opens at 5:30amFree WiFi4
5DepartureGates close at 8:45am5
6ArrivalGates open at 7am6