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 |
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 |
TerminalId | AirportCode | FloorSpace | NumberOfGates |
---|---|---|---|
(→ Airports.AirportCode) | |||
1 | LAX | 3000000 | 100 |
2 | JFK | 500000 | 80 |
RestrictionId | SizeLimit | ProhibitedItem | Airlines |
---|---|---|---|
(→ Flights.AirlineName) | |||
1 | Over 12oz | Water bottles | United |
2 | More than 100ml | Chemical substances | Delta |