id | name |
---|---|
1 | Auckland |
2 | Los Angeles |
3 | Tokyo |
4 | Dubai |
5 | New York |
id | from_airport_id | to_airport_id |
---|---|---|
(→ airports.id) | (→ airports.id) | |
1 | 1 | 2 |
2 | 3 | 4 |
3 | 5 | 6 |
4 | 7 | 8 |
5 | 9 | 10 |
id | name |
---|---|
1 | Boeing |
2 | Airbus |
3 | Embraer |
4 | De Havilland Canada |
plane_id | manufacturer_id |
---|---|
(→ planes.id) | (→ manufacturers.id) |
1 | 1 |
2 | 1 |
3 | 2 |
4 | 3 |
5 | 4 |
id | model | number_of_seats |
---|---|---|
1 | Boeing 787 | 180 |
2 | Boeing 787 | 200 |
3 | Airbus A380 | 180 |
4 | Airbus A380 | 200 |
5 | Bombardier CRJ900 | 88 |
6 | Bombardier Q400 | 78 |