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