## Flights

FlightID | AirlineName | DepartureTime | ArrivalTime | DestinationCity | NumberOfPassengers | BaggageAllowance
--- | --- | --- | --- | --- | --- | ---
1 | United | 2021-08-26 10:00:00 | 2021-08-26 17:00:00 | Los Angeles | 200 | 25
2 | Delta | 2021-08-27 12:00:00 | 2021-08-27 19:00:00 | New York | 150 | 20

## Airports

AirportCode | AirportName | City | Country | Latitude | Longitude
--- | --- | --- | --- | --- | ---
LAX | Los Angeles International Airport | Los Angeles | USA | -118.405594 | 33.942934
JFK | John F Kennedy International Airport | New York | USA | -73.778929 | 40.639742

## Terminals

TerminalId | AirportCode | FloorSpace | NumberOfGates
--- | --- | --- | ---
| (→ Airports.AirportCode) |  |
1 | LAX | 3000000 | 100
2 | JFK | 500000 | 80

## Security

RestrictionId | SizeLimit | ProhibitedItem | Airlines
--- | --- | --- | ---
|  |  | (→ Flights.AirlineName)
1 | Over 12oz | Water bottles | United
2 | More than 100ml | Chemical substances | Delta