## Gate

gate_id | airport_code | terminal_number
--- | --- | ---
1 | JFK | 3
2 | LAX | 2
3 | ORD | 1
4 | ATL | 6
5 | YUL | 7

## Facility

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

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

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

aircraft_id | model | capacity
--- | --- | ---
1 | Airbus A380 | 450
2 | Boeing 747 | 400
3 | Airbus A321 | 200
4 | Boeing 737 | 180
5 | Embraer E190 | 110