| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| id | Model | plane_type | max_passenger_capacity | range_km |
|---|---|---|---|---|
| 1 | Boeing | Passenger | 280 | 13600.0 |
| 2 | Airbus | Passenger | 440 | 14800.0 |
| 3 | Bombardier Aerospace | Business Jet | 19 | 7700.0 |
| 4 | Gulfstream Aerospace | Business Jet | 18 | 7500.0 |
| 5 | Embraer Executive Jets | Business Jet | 12 | 6000.0 |