id | name | city | country |
---|---|---|---|
1 | Los Angeles International Airport | Los Angeles | USA |
2 | Dubai International Airport | Dubai | UAE |
3 | London Heathrow Airport | London | UK |
4 | Tokyo Haneda Airport | Tokyo | Japan |
5 | Sydney Kingsford Smith Airport | Sydney | Australia |
id | name | alliance | independent_carrier |
---|---|---|---|
1 | American Airlines | OneWorld | 0 |
2 | Emirates | None | 1 |
3 | British Airways | OneWorld | 0 |
4 | ANA | None | 0 |
5 | Qantas | OneWorld | 0 |
id | model | max_capacity |
---|---|---|
1 | Airbus A320 | 180 |
2 | Boeing 747 | 400 |
3 | Airbus A380 | 850 |
4 | Boeing 777 | 360 |
5 | Embraer E190 | 100 |
airline_alliance | aircraft |
---|---|
(→ Airlines.name) | (→ Aircrafts.model) |
American Airlines | Airbus A320 |
British Airways | Boeing 747 |
independent_carrier | aircraft |
---|---|
(→ Airlines.name) | (→ Aircrafts.model) |
Emirates | Airbus A320 |
Qantas | Boeing 777 |
flight_id | departure_airport | arrival_airport | airline_id | aircraft_id |
---|---|---|---|---|
(→ Airports.id) | (→ Airports.id) | (→ Airlines.id) | (→ Aircrafts.id) | |
1 | 1 | 2 | 1 | 1 |
2 | 2 | 1 | 2 | 2 |
3 | 3 | 4 | 3 | 3 |
4 | 4 | 3 | 4 | 4 |
5 | 5 | 1 | 5 | 5 |