Flights

FlightIDAirlineNameDepartureTimeArrivalTimeDestinationCityNumberOfPassengersBaggageAllowance
1United2021-08-26 10:00:002021-08-26 17:00:00Los Angeles20025
2Delta2021-08-27 12:00:002021-08-27 19:00:00New York15020

Airports

AirportCodeAirportNameCityCountryLatitudeLongitude
LAXLos Angeles International AirportLos AngelesUSA-118.40559433.942934
JFKJohn F Kennedy International AirportNew YorkUSA-73.77892940.639742

Terminals

TerminalIdAirportCodeFloorSpaceNumberOfGates
(→ Airports.AirportCode)
1LAX3000000100
2JFK50000080

Security

RestrictionIdSizeLimitProhibitedItemAirlines
(→ Flights.AirlineName)
1Over 12ozWater bottlesUnited
2More than 100mlChemical substancesDelta