Commercial_Space

idNameRevenueLocationFloorNumber
1Food Court$1 MillionMain Terminal2
2Food CourtMore than $1 MillionConcourse A3
3Retail Shop$1 MillionDepartures Lounge1
4Retail ShopLess than $1 MillionArrivals Hall0

Flight

idDestinationDepartureTimeArrivalTimeAircraftTypeGateNumber
1London2022-06-01 10:00:002022-06-01 12:00:00Airbus A380101
2New York2022-06-01 13:00:002022-06-01 17:00:00Boeing 777102

Passenger

idFirstNameLastNameDateOfBirthNationality
1JohnDoe1990-01-01USA
2JaneSmith1985-05-15UK

Booking

idFlightIdPassengerIdClass
111Economy
222Business

Baggage

idFlightIdWeightInKgDescription
1120Luggage of passenger 1
2230Luggage of passenger 2

SecurityCheckpoint

idFloorNumberEntranceExit
12Security Checkpoint AExit A
21Security Checkpoint BExit B