id | name | location | capacity |
---|---|---|---|
1 | JFK International | Queens, New York City | 70000 |
2 | Los Angeles International | Los Angeles County, California | 90000 |
flight_id | airport_id | departure | arrival | passengers |
---|---|---|---|---|
(→ Airports.id) | ||||
1 | 1 | 2022-06-01 08:00:00 | 2022-06-01 12:00:00 | 200 |
2 | 1 | 2022-06-02 10:00:00 | 2022-06-02 14:00:00 | 250 |
runway_id | airport_id | length | width | construction_date |
---|---|---|---|---|
(→ Airports.id) | ||||
1 | 1 | 10000 | 150 | 2015-05-01 |
2 | 1 | 12000 | 180 | 2017-06-01 |
taxiway_id | runway_id | airport_id | length | width | construction_date |
---|---|---|---|---|---|
(→ Runways.runway_id) | (→ Airports.id) | ||||
1 | 1 | None | 1000 | 100 | 2015-05-01 |
2 | 1 | None | 1100 | 105 | 2017-06-01 |
terminal_id | airport_id | area | capacity | construction_date |
---|---|---|---|---|
(→ Airports.id) | ||||
1 | 1 | 50000 | 5000 | 2015-05-01 |
2 | 1 | 60000 | 6000 | 2017-06-01 |
infrastructure_id | airport_id | Airport_Infrastructure | Construction_Date |
---|---|---|---|
(→ Airports.id) | |||
1 | 1 | Runway | 2015-05-01 |
2 | 1 | Taxiway | 2017-06-01 |