## Airports

id | name | city | country
--- | --- | --- | ---
1 | John F. Kennedy International | New York | USA
2 | Los Angeles International | Los Angeles | USA
3 | Dubai International | Dubai | UAE
4 | Heathrow Airport | London | UK
5 | Charles de Gaulle Airport | Paris | France

## Airlines

id | airline_name | headquarters_city | headquarters_country
--- | --- | --- | ---
1 | American Airlines | Fort Worth | USA
2 | Delta Air Lines | Atlanta | USA
3 | Emirates | Dubai | UAE
4 | British Airways | London | UK
5 | Air France | Paris | France

## Planes

id | manufacturer_name | model_name | purpose | max_passenger_capacity | range_km
--- | --- | --- | --- | --- | ---
1 | Boeing | 787-9 Dreamliner | Passenger | 280 | 13600.0
2 | Airbus | A350-1000 | Passenger | 440 | 14800.0
3 | Bombardier Aerospace | Global 7500 | Business Jet | 19 | 7700.0
4 | Gulfstream Aerospace | G650ER | Business Jet | 18 | 7500.0
5 | Embraer Executive Jets | Legacy 650 | Business Jet | 12 | 6000.0

## Routes

id | source_airport_id | destination_airport_id | airline_id | departure_time | arrival_time
--- | --- | --- | --- | --- | ---
| (→ Airports.id) | (→ Airports.id) | (→ Airlines.id) |  |
1 | 1 | 2 | 1 | 2022-01-01 12:00:00 | 2022-01-01 16:00:00
2 | 2 | 3 | 3 | 2022-01-01 14:00:00 | 2022-01-01 20:00:00
3 | 4 | None | 4 | 2022-01-01 10:00:00 | 2022-01-01 14:00:00
4 | 5 | 1 | 5 | 2022-01-01 16:00:00 | 2022-01-01 10:00:00
5 | 1 | 2 | 2 | 2022-01-01 15:00:00 | 2022-01-01 19:00:00

## Flights

id | route_id | plane_id | flight_number | departure_date | scheduled_departure_time | actual_departure_time
--- | --- | --- | --- | --- | --- | ---
| (→ Routes.id) | (→ Planes.id) |  |  |  |
1 | 1 | 1 | AA123 | 2022-01-01 | 12:00:00 | None
2 | 2 | 2 | EK123 | 2022-01-01 | 14:00:00 | None
3 | None | 2 | BA123 | 2022-01-01 | 10:00:00 | None
4 | 4 | 2 | AF123 | 2022-01-01 | 16:00:00 | None
5 | 5 | None | DL123 | 2022-01-01 | 15:00:00 | None

## Pilots

id | first_name | last_name | license_number | rating_level | total_flight_hours
--- | --- | --- | --- | --- | ---
1 | John | Doe | ABCD1234 | ATPL | 5000
2 | Jane | Smith | EFGH5678 | ATPL | 7000
3 | Michael | Johnson | IJKL9012 | ATPL | 6000
4 | Sarah | Williams | LMNO3456 | ATPL | 4500
5 | David | Brown | PQRS7890 | ATPL | 5500

## AssignsPilotToFlight

pilot_id | flight_id | assignment_date
--- | --- | ---
(→ Pilots.id) | (→ Flights.id) |
1 | 1 | 2022-01-01
2 | 2 | 2022-01-01
3 | 3 | 2022-01-01
4 | 4 | 2022-01-01
5 | 5 | 2022-01-01