## airports

id | name
--- | ---
1 | Auckland
2 | Los Angeles
3 | Tokyo
4 | Dubai
5 | New York

## flights

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

## manufacturers

id | name
--- | ---
1 | Boeing
2 | Airbus
3 | Embraer
4 | De Havilland Canada

## plane_details

plane_id | manufacturer_id
--- | ---
(→ planes.id) | (→ manufacturers.id)
1 | 1
2 | 1
3 | 2
4 | 3
5 | 4

## planes

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