Gate

gate_idairport_codeterminal_number
1JFK3
2LAX2
3ORD1
4ATL6
5YUL7

Facility

facility_idnamedescription
1Baggage ClaimA place where passengers collect their luggage
2RestaurantA place where passengers can eat
3Shopping CenterA place where passengers can shop
4Information DeskA place where passengers can get information about flights
5Currency ExchangeA place where passengers can exchange currency

Gate_Facility

gate_facility_idgate_idfacility_id
(→ Gate.gate_id)(→ Facility.facility_id)
111
212
323
434
545
621
731
841
951

Flight

flight_idairline_namedeparture_timearrival_time
1United Airlines08-05-2022 9:00 AM08-05-2022 11:00 PM
2Delta Airlines08-05-2022 10:00 AM08-05-2022 12:00 PM
3American Airlines08-05-2022 11:00 AM08-05-2022 1:00 PM
4Southwest Airlines08-05-2022 12:00 PM08-05-2022 2:00 PM
5Spirit Airlines08-05-2022 1:00 PM08-05-2022 3:00 PM

Aircraft

aircraft_idmodelcapacity
1Airbus A380450
2Boeing 747400
3Airbus A321200
4Boeing 737180
5Embraer E190110