id | name | country |
---|---|---|
1 | New York | USA |
2 | London | UK |
3 | Tokyo | Japan |
4 | Paris | France |
5 | Dubai | UAE |
id | latitude | longitude |
---|---|---|
1 | -73.985428 | -109.136635 |
2 | 51.507223 | -0.127503 |
3 | 35.689501 | 139.691699 |
4 | 48.8566 | 2.352222 |
5 | 25.27439 | 55.29888 |
id | name | city_id | coordinates_id |
---|---|---|---|
(→ City.id) | (→ Coordinates.id) | ||
1 | John F. Kennedy International Airport | 1 | 1 |
2 | Heathrow Airport | 2 | 2 |
3 | Narita International Airport | 3 | 3 |
4 | Charles de Gaulle Airport | 4 | 4 |
5 | Dubai International Airport | 5 | 5 |
id | name | headquarter_city_id |
---|---|---|
(→ City.id) | ||
1 | American Airlines | 1 |
2 | British Airways | 2 |
3 | All Nippon Airways | 3 |
4 | Air France-KLM | 4 |
5 | Emirates | 5 |
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 |