Commercial_Space
id | Name | Revenue | Location | FloorNumber |
1 | Food Court | $1 Million | Main Terminal | 2 |
2 | Food Court | More than $1 Million | Concourse A | 3 |
3 | Retail Shop | $1 Million | Departures Lounge | 1 |
4 | Retail Shop | Less than $1 Million | Arrivals Hall | 0 |
Flight
id | Destination | DepartureTime | ArrivalTime | AircraftType | GateNumber |
1 | London | 2022-06-01 10:00:00 | 2022-06-01 12:00:00 | Airbus A380 | 101 |
2 | New York | 2022-06-01 13:00:00 | 2022-06-01 17:00:00 | Boeing 777 | 102 |
Passenger
id | FirstName | LastName | DateOfBirth | Nationality |
1 | John | Doe | 1990-01-01 | USA |
2 | Jane | Smith | 1985-05-15 | UK |
Booking
id | FlightId | PassengerId | Class |
1 | 1 | 1 | Economy |
2 | 2 | 2 | Business |
Baggage
id | FlightId | WeightInKg | Description |
1 | 1 | 20 | Luggage of passenger 1 |
2 | 2 | 30 | Luggage of passenger 2 |
SecurityCheckpoint
id | FloorNumber | Entrance | Exit |
1 | 2 | Security Checkpoint A | Exit A |
2 | 1 | Security Checkpoint B | Exit B |