DutyFreeShops
ShopID | Name | Location | Size | AnnualRevenue |
1 | Global Traveller | Terminal 3 | 12000.0 | 678900.0 |
2 | Eastern Delicacies | Terminal 1 | 8000.0 | 545000.0 |
SouvenirStores
StoreID | Name | Location | InventoryCount | AveragePurchaseAmount |
1 | Gift World | Terminal 3 | 500 | 25.0 |
2 | Memories of Journey | Terminal 2 | 700 | 20.0 |
Flights
FlightID | AirlineName | DepartureTime | ArrivalTime | OriginAirportCode | DestinationAirportCode |
1 | United Airlines | 2023-02-12 10:00:00 | 2023-02-12 13:30:00 | JFK | LAX |
2 | Delta Airlines | 2023-02-12 14:00:00 | 2023-02-12 17:30:00 | ATL | SEA |
PassengerCheckIns
CheckInID | FlightID | PassengerName | BoardingPassNumber | CheckInTime |
| (→ Flights.FlightID) | | | |
1 | 1 | John Doe | 1234 | 2023-02-12 09:30:00 |
2 | 2 | Emma Smith | 5678 | 2023-02-12 10:30:00 |