Airports

idnamecity
1JFK InternationalNew York
2LAX InternationalLos Angeles
3ORD InternationalChicago
4ATL Hartsfield-JacksonAtlanta
5SEA Seattle/TacomaSeattle

Terminals

idairportIdterminalName
(→ Airports.id)
11Terminal 1
21Terminal 2
31Terminal 3
42Terminal A
52Terminal B
63Terminal C
73Terminal D

Gates

idterminalIdgateNumber
(→ Terminals.id)
1110
2120
3130
4210
5220
6310
7320
8410
9420

Flights

flightIDdepartureGateIdarrivalGateIddepartureTimearrivalTimedepartureAirportIdarrivalAirportId
(→ Gates.id)(→ Gates.id)(→ Airports.id)(→ Airports.id)
1112022-09-01 07:00:002022-09-01 08:00:0012
2222022-09-01 08:00:002022-09-01 09:00:0012
3332022-09-01 09:00:002022-09-01 10:00:0012
4442022-09-01 10:00:002022-09-01 11:00:0012
5552022-09-01 11:00:002022-09-01 12:00:0012

RetailOutlets

idtypelocationterminalId
(→ Terminals.id)
1Duty-Free ShopTerminal 33
2Duty-Free ShopConcourse E2
3Souvenir StoreTerminal 33
4Souvenir StoreConcourse F2
5BookshopTerminal 22
6Coffee ShopTerminal 11
7RestaurantTerminal 33