| id | name | city | country | latitude | longitude |
|---|---|---|---|---|---|
| 1 | John F Kennedy International | New York City | USA | 40.641987 | -73.778604 |
| 2 | Los Angeles International | Los Angeles | USA | 33.944826 | -118.405889 |
| 3 | Heathrow Airport | London | UK | 51.477025 | -0.461866 |
| 4 | Dubai International | Dubai | UAE | 25.259648 | 55.285619 |
| 5 | Tokyo Haneda | Tokyo | Japan | 35.601194 | 139.737522 |
| id | airline_name | type_of_alliance | home_airport_id |
|---|---|---|---|
| (→ Airports.id) | |||
| 1 | Alliance Airways | Airline Alliance | 1 |
| 2 | Budget Airlines | Airline Alliance | 2 |
| 3 | Fly High Independent | Independent Carrier | 3 |
| 4 | Global Travellers | Independent Carrier | 4 |
| 5 | Oceanic Flyers | No Alliance | 5 |
| flight_number | departure_time | arrival_time | airline_id | aircraft_model | source_airport_id | destination_airport_id |
|---|---|---|---|---|---|---|
| (→ Airlines.id) | (→ Airports.id) | (→ Airports.id) | ||||
| 1 | 2022-01-01 10:00:00 | 2022-01-01 14:00:00 | 1 | Airbus A320 | 1 | 2 |
| 2 | 2022-01-01 12:00:00 | 2022-01-01 17:00:00 | 2 | Boeing B737 | 3 | 4 |
| 3 | 2022-01-02 08:00:00 | 2022-01-02 12:00:00 | 3 | Airbus A320 | 4 | 5 |
| 4 | 2022-01-02 10:00:00 | 2022-01-02 15:00:00 | 4 | Boeing B787 | 5 | 1 |
| 5 | 2022-01-03 11:00:00 | 2022-01-03 16:00:00 | 5 | Airbus A320 | 2 | 3 |
| pilot_license_number | first_name | last_name | date_of_birth | rating_level |
|---|---|---|---|---|
| 1 | John | Smith | 1990-01-01 | A |
| 2 | Jane | Doe | 1985-05-05 | A |
| 3 | Alice | Wright | 1989-02-12 | B |
| 4 | Bob | Johnson | 1992-03-13 | C |
| assignment_id | flight_number | pilot_license_number |
|---|---|---|
| (→ Flights.flight_number) | (→ Pilots.pilot_license_number) | |
| 1 | 1 | 1 |
| 2 | 1 | 2 |
| 3 | 2 | 3 |
| 4 | 2 | 4 |
| 5 | 3 | 1 |