| 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 |