id | Name | Type | Location_Within_Terminal | Operating_Hours |
---|---|---|---|---|
1 | First Currency | Currency Exchange Service | Near Gate 10 | 8 AM - 6 PM |
2 | Second Currency | Currency Exchange Service | Before Security Check | 7 AM - 9 PM |
3 | Bank of America ATM | ATM Machine | Near Gate 10 | Open 24 Hours |
4 | Citi Bank Branch | ATM Machine | After Security Check | 8 AM - 5 PM |
id | name | location |
---|---|---|
1 | Terminal A | Gate Area |
2 | Terminal B | International Departure |
id | airline_name | terminal_id |
---|---|---|
(→ Terminals.id) | ||
1 | United Airlines | 1 |
2 | Delta Airlines | 2 |
flight_number | departure_time | arrival_time | origin_airport | destination_airport | airline_id |
---|---|---|---|---|---|
(→ Airlines.id) | |||||
101 | 2023-04-15 06:00:00 | 2023-04-15 08:00:00 | LAX | JFK | 1 |
102 | 2023-04-15 07:00:00 | 2023-04-15 09:00:00 | ORD | LHR | 2 |
claim_number | carousel_location | airport_code |
---|---|---|
(→ Airports.code) | ||
101 | Carousel 3 | LAX |
102 | Carousel 6 | ORD |
code | name | city | country |
---|---|---|---|
LAX | Los Angeles International Airport | Los Angeles | USA |
ORD | O'Hare International Airport | Chicago | USA |