## Airports

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

## Airlines

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

## Flights

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

## Pilots

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

## Assignments

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