Flights

flight_numberdeparturearrivalaircraft_id
(→ Aircrafts.aircraft_id)
12023-01-01 07:002023-01-01 10:001
22023-01-01 08:002023-01-01 11:002
32023-01-01 09:002023-01-01 12:003
42023-01-01 10:002023-01-01 13:004
52023-01-01 11:002023-01-01 14:005

Passengers

passenger_idfirstnamelastname
1JohnDoe
2JaneSmith
3AliceBrown
4MichaelJohnson
5EmilyWilliams

Aircrafts

aircraft_idmodelcapacity
1Boeing 747400
2Airbus A380800
3Bombardier CRJ20050
4Embraer E195100
5Airbus A320160

Locations

location_idterminal_numbergate_number
1310
2120
3230
4140
5250

RetailOutlets

outlet_idnamelocation_id
(→ Locations.location_id)
1Duty-Free Shop1
2Duty-Free Shop5
3Souvenir Store1
4Souvenir Store5
5Bookstore2
6Coffee Shop3
7Fast Food Restaurant4