Airports

idnamelocationcapacity
1JFK InternationalQueens, New York City70000
2Los Angeles InternationalLos Angeles County, California90000

Flight_Info

flight_idairport_iddeparturearrivalpassengers
(→ Airports.id)
112022-06-01 08:00:002022-06-01 12:00:00200
212022-06-02 10:00:002022-06-02 14:00:00250

Runways

runway_idairport_idlengthwidthconstruction_date
(→ Airports.id)
11100001502015-05-01
21120001802017-06-01

Taxiways

taxiway_idrunway_idairport_idlengthwidthconstruction_date
(→ Runways.runway_id)(→ Airports.id)
11None10001002015-05-01
21None11001052017-06-01

Terminals

terminal_idairport_idareacapacityconstruction_date
(→ Airports.id)
115000050002015-05-01
216000060002017-06-01

Infrastructure

infrastructure_idairport_idAirport_InfrastructureConstruction_Date
(→ Airports.id)
11Runway2015-05-01
21Taxiway2017-06-01