| 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 |