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 |