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 |