| gate_id | airport_code | terminal_number |
|---|---|---|
| 1 | JFK | 3 |
| 2 | LAX | 2 |
| 3 | ORD | 1 |
| 4 | ATL | 6 |
| 5 | YUL | 7 |
| facility_id | name | description |
|---|---|---|
| 1 | Baggage Claim | A place where passengers collect their luggage |
| 2 | Restaurant | A place where passengers can eat |
| 3 | Shopping Center | A place where passengers can shop |
| 4 | Information Desk | A place where passengers can get information about flights |
| 5 | Currency Exchange | A place where passengers can exchange currency |
| gate_facility_id | gate_id | facility_id |
|---|---|---|
| (→ Gate.gate_id) | (→ Facility.facility_id) | |
| 1 | 1 | 1 |
| 2 | 1 | 2 |
| 3 | 2 | 3 |
| 4 | 3 | 4 |
| 5 | 4 | 5 |
| 6 | 2 | 1 |
| 7 | 3 | 1 |
| 8 | 4 | 1 |
| 9 | 5 | 1 |
| flight_id | airline_name | departure_time | arrival_time |
|---|---|---|---|
| 1 | United Airlines | 08-05-2022 9:00 AM | 08-05-2022 11:00 PM |
| 2 | Delta Airlines | 08-05-2022 10:00 AM | 08-05-2022 12:00 PM |
| 3 | American Airlines | 08-05-2022 11:00 AM | 08-05-2022 1:00 PM |
| 4 | Southwest Airlines | 08-05-2022 12:00 PM | 08-05-2022 2:00 PM |
| 5 | Spirit Airlines | 08-05-2022 1:00 PM | 08-05-2022 3:00 PM |
| aircraft_id | model | capacity |
|---|---|---|
| 1 | Airbus A380 | 450 |
| 2 | Boeing 747 | 400 |
| 3 | Airbus A321 | 200 |
| 4 | Boeing 737 | 180 |
| 5 | Embraer E190 | 110 |