## 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