| id | name | location |
|---|---|---|
| 1 | John F. Kennedy International Airport | New York |
| 2 | Los Angeles International Airport | California |
| id | airportId | length | width |
|---|---|---|---|
| (→ Airports.id) | |||
| 1 | 1 | 9872.3 | 150.0 |
| 2 | 1 | 9945.6 | 160.0 |
| id | airportId | terminalNumber | capacity |
|---|---|---|---|
| (→ Airports.id) | |||
| 1 | 1 | 1 | 20 |
| 2 | 1 | 2 | 30 |
| id | airlineName | headquarters |
|---|---|---|
| 1 | American Airlines | Fort Worth, Texas |
| 2 | United Airlines | Chicago, Illinois |
| 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 |
| 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 |
| id | name |
|---|---|
| 1 | Air Traffic Controller |
| 2 | Ground Staff |