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