| 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 |