Flight

flightIDairlinedepartureAirportarrivalAirportdateduration
1UnitedEWRIAH2023-08-01 06:00:004
2DeltaATLLAX2023-08-02 07:00:005
3American AirlinesDFWMIA2023-08-03 08:00:004
4SouthwestMCOPHX2023-08-04 09:00:003
5Alaska AirlinesSEAPDX2023-08-05 10:00:002

Employee

employeeIDnamepositionhireDatesalary
1John DoePilot2020-06-01100000.0
2Jane SmithFlight Attendant2021-05-0150000.0
3Bob JohnsonMechanic2019-07-0160000.0
4Emily DavisCustomer Service Representative2022-08-0140000.0
5Chris BrownSecurity Officer2018-09-0135000.0

Passenger

passengerIDfirstNamelastNamebirthdatenationality
1AlexanderSmith1990-01-15USA
2SamanthaJohnson1995-02-20UK
3DavidWilliams1988-03-25Canada
4EmmaMartinez2000-04-05Spain
5MichaelDavis1992-05-10Australia

Restaurant

restaurantIDairportIDnamelocationtypeopeningHours
11Grand Central Oyster BarTerminal ASeafood9 AM to 11 PM
22The Flying PizzaTerminal BItalian11 AM to 9 PM
33Taste of Texas BBQTerminal CBBQ10 AM to 8 PM
44Café de la MaisonTerminal DFrench8 AM to 6 PM
55Green Leaf Salad BarTerminal ESalad7 AM to 7 PM

Bar

barIDairportIDnamelocationcapacityopeningHours
11Gateway LoungeConcourse A509 AM to 11 PM
22Beer GardenConcourse B7511 AM to 9 PM
33Whiskey SkyConcourse C10010 AM to 8 PM
44Rooftop Wine BarConcourse D708 AM to 6 PM
55Sunset Margarita BarConcourse E807 AM to 7 PM