## Airports

id | name | location | capacity
--- | --- | --- | ---
1 | JFK International | Queens, New York City | 70000
2 | Los Angeles International | Los Angeles County, California | 90000

## Flight_Info

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

## Runways

runway_id | airport_id | length | width | construction_date
--- | --- | --- | --- | ---
| (→ Airports.id) |  |  |
1 | 1 | 10000 | 150 | 2015-05-01
2 | 1 | 12000 | 180 | 2017-06-01

## Taxiways

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

## Terminals

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

infrastructure_id | airport_id | Airport_Infrastructure | Construction_Date
--- | --- | --- | ---
| (→ Airports.id) |  |
1 | 1 | Runway | 2015-05-01
2 | 1 | Taxiway | 2017-06-01