Financial_Services

idNameTypeLocation_Within_TerminalOperating_Hours
1First CurrencyCurrency Exchange ServiceNear Gate 108 AM - 6 PM
2Second CurrencyCurrency Exchange ServiceBefore Security Check7 AM - 9 PM
3Bank of America ATMATM MachineNear Gate 10Open 24 Hours
4Citi Bank BranchATM MachineAfter Security Check8 AM - 5 PM

Terminals

idnamelocation
1Terminal AGate Area
2Terminal BInternational Departure

Airlines

idairline_nameterminal_id
(→ Terminals.id)
1United Airlines1
2Delta Airlines2

Flight_Details

flight_numberdeparture_timearrival_timeorigin_airportdestination_airportairline_id
(→ Airlines.id)
1012023-04-15 06:00:002023-04-15 08:00:00LAXJFK1
1022023-04-15 07:00:002023-04-15 09:00:00ORDLHR2

Baggage_Claims

claim_numbercarousel_locationairport_code
(→ Airports.code)
101Carousel 3LAX
102Carousel 6ORD

Airports

codenamecitycountry
LAXLos Angeles International AirportLos AngelesUSA
ORDO'Hare International AirportChicagoUSA