## Geographical_Position

id | name | country
--- | --- | ---
1 | New York | USA
2 | London | UK
3 | Tokyo | Japan
4 | Paris | France
5 | Dubai | UAE

## Flight

id | airport_from_id | airport_to_id | airline_id | departure_time | arrival_time
--- | --- | --- | --- | --- | ---
| (→ Airport.id) | (→ Airport.id) | (→ Airline.id) |  |
1 | 1 | 2 | 1 | 2022-01-01 12:00:00 | 2022-01-01 18:00:00
2 | 3 | 4 | 2 | 2022-01-01 08:00:00 | 2022-01-01 14:00:00
3 | 5 | 1 | 3 | 2022-01-02 12:00:00 | 2022-01-02 18:00:00
4 | 2 | 3 | 4 | 2022-01-02 08:00:00 | 2022-01-02 14:00:00
5 | 4 | 5 | 5 | 2022-01-03 12:00:00 | 2022-01-03 18:00:00

## Runway

id | airport_id | length | width | surface_type
--- | --- | --- | --- | ---
| (→ Airport.id) |  |  |
1 | 1 | 10000 | 200 | Asphalt
2 | 2 | 10000 | 200 | Concrete
3 | 3 | 9000 | 200 | Asphalt
4 | 4 | 9000 | 200 | Concrete
5 | 5 | 12000 | 200 | Asphalt

## Airport

id | name | city_id
--- | --- | ---
|  | (→ Geographical_Position.id)
1 | John F. Kennedy International Airport | 1
2 | Heathrow Airport | 2
3 | Narita International Airport | 3
4 | Charles de Gaulle Airport | 4
5 | Dubai International Airport | 5

## Airline

id | name | headquarter_city_id
--- | --- | ---
|  | (→ Geographical_Position.id)
1 | American Airlines | 1
2 | British Airways | 2
3 | All Nippon Airways | 3
4 | Air France-KLM | 4
5 | Emirates | 5