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 |