## Airports

id | name | location
--- | --- | ---
1 | John F. Kennedy International Airport | New York
2 | Los Angeles International Airport | California

## Runways

id | airportId | length | width
--- | --- | --- | ---
| (→ Airports.id) |  |
1 | 1 | 9872.3 | 150.0
2 | 1 | 9945.6 | 160.0

## Terminals

id | airportId | terminalNumber | capacity
--- | --- | --- | ---
| (→ Airports.id) |  |
1 | 1 | 1 | 20
2 | 1 | 2 | 30

## Airlines

id | airlineName | headquarters
--- | --- | ---
1 | American Airlines | Fort Worth, Texas
2 | United Airlines | Chicago, Illinois

## Flights

id | departureTerminal | arrivalTerminal | departureTime | arrivalTime | airplaneType | airlineId
--- | --- | --- | --- | --- | --- | ---
| (→ Terminals.id) | (→ Terminals.id) |  |  |  | (→ Airlines.id)
1 | 1 | 2 | 2023-04-01 10:00:00 | 2023-04-01 12:00:00 | Boeing 737 | 1
2 | 1 | 2 | 2023-04-01 14:00:00 | 2023-04-01 16:00:00 | Airbus A320 | 2

## Personnel

id | role | salary | workHours
--- | --- | --- | ---
| (→ Roles.name) |  |
1 | Air Traffic Controller | 60000.0 | 40
2 | Air Traffic Controller | 65000.0 | 40
3 | Ground Staff | 60000.0 | 40
4 | Ground Staff | 65000.0 | 40

## Roles

id | name
--- | ---
1 | Air Traffic Controller
2 | Ground Staff