## Airlines

id | name | headquarters
--- | --- | ---
1 | American Airlines | Fort Worth
2 | Delta Airlines | Atlanta
3 | United Airlines | Chicago
4 | Southwest Airlines | Dallas
5 | Alaska Airlines | Seattle

## AircraftTypes

id | typeName | manufacturer
--- | --- | ---
1 | 737 | Boeing
2 | A320 | Airbus
3 | 787 | Boeing
4 | A350 | Airbus
5 | A380 | Airbus

## Planes

id | model | number_of_seats | aircraftTypeId | airlineId
--- | --- | --- | --- | ---
|  |  | (→ AircraftTypes.id) | (→ Airlines.id)
1 | 737-800 | 169 | 1 | 1
2 | A320-200 | 180 | 2 | 2
3 | 787-9 | 284 | 3 | 3
4 | A350-1000 | 440 | 4 | 4
5 | A380-800 | 514 | 5 | 5
6 | Boeing 747-8i | 467 | 6 | 6

## BoeingPlanes

planeId | boeing
--- | ---
(→ Planes.id) |
1 | 0
2 | 0
3 | 0
4 | 0
5 | 0

## AirbusPlanes

planeId | airbus
--- | ---
(→ Planes.id) |
2 | 0
3 | 0
4 | 0
5 | 0
6 | 0

## FlightRoutes

routeId | originAirportCode | destinationAirportCode | flightNumber | planeId
--- | --- | --- | --- | ---
|  |  |  | (→ Planes.id)
1 | JFK | LAX | 123 | 1
2 | ORD | ATL | 456 | 2
3 | IAD | MCO | 789 | 3
4 | SEA | PHX | 101 | 4
5 | SFO | YVR | 202 | 5
6 | EWR | MIA | 303 | 6