| id | name | country |
|---|---|---|
| 1 | New York | USA |
| 2 | London | UK |
| 3 | Tokyo | Japan |
| 4 | Paris | France |
| 5 | Dubai | UAE |
| 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 |
| 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 |
| 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 |
| 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 |