Flights
flight_number | departure | arrival | aircraft_id |
| | | (→ Aircrafts.aircraft_id) |
1 | 2023-01-01 07:00 | 2023-01-01 10:00 | 1 |
2 | 2023-01-01 08:00 | 2023-01-01 11:00 | 2 |
3 | 2023-01-01 09:00 | 2023-01-01 12:00 | 3 |
4 | 2023-01-01 10:00 | 2023-01-01 13:00 | 4 |
5 | 2023-01-01 11:00 | 2023-01-01 14:00 | 5 |
Passengers
passenger_id | firstname | lastname |
1 | John | Doe |
2 | Jane | Smith |
3 | Alice | Brown |
4 | Michael | Johnson |
5 | Emily | Williams |
Aircrafts
aircraft_id | model | capacity |
1 | Boeing 747 | 400 |
2 | Airbus A380 | 800 |
3 | Bombardier CRJ200 | 50 |
4 | Embraer E195 | 100 |
5 | Airbus A320 | 160 |
Locations
location_id | terminal_number | gate_number |
1 | 3 | 10 |
2 | 1 | 20 |
3 | 2 | 30 |
4 | 1 | 40 |
5 | 2 | 50 |
RetailOutlets
outlet_id | name | location_id |
| | (→ Locations.location_id) |
1 | Duty-Free Shop | 1 |
2 | Duty-Free Shop | 5 |
3 | Souvenir Store | 1 |
4 | Souvenir Store | 5 |
5 | Bookstore | 2 |
6 | Coffee Shop | 3 |
7 | Fast Food Restaurant | 4 |