Aircraft

idmodelcapacity
1Boeing 737160
2Airbus A320180
3Bombardier Q40070
4Embraer E190100
5Cessna Caravan9

Flight

iddeparture_timearrival_timeaircraft_id
(→ Aircraft.id)
12023-04-01 08:00:002023-04-01 11:00:001
22023-04-01 12:00:002023-04-01 15:00:002
32023-04-01 16:00:002023-04-01 19:00:003
42023-04-01 19:00:002023-04-01 22:00:004
52023-04-01 22:00:002023-04-02 02:00:005

Departure

idflight_idgate_number
(→ Flight.id)
111
222
333
444
555

Arrival

idflight_idgate_number
(→ Flight.id)
111
222
333
444
555

Facility

idname
1Lounge Access
2Restaurant
3Shops
4Car Rental
5Hotel

Access_to_facility

idfacility_idflight_id
(→ Facility.id)(→ Flight.id)
111
212
323
424
515
616
727
828