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 |