Airport

idNameNavigation_SystemCommunication_System
1HeathrowVOR/DMEAMF
2JFK InternationalILSATIS
3Los Angeles InternationalNDB/DMEAFIS
4Charles de GaulleVORFM
5Hong Kong InternationalDMEATC

Runway

idLengthWidthAirportId
(→ Airport.id)
13000.060.01
22800.075.02
33100.065.03
42900.070.04
53200.060.05

Aircraft

idModelRegistrationNumberCapacityHomeAirportId
(→ Airport.id)
1Boeing 747G-BNNG4001
2Airbus A380N123BA4502
3Boeing 777PH-BFD3503
4Airbus A350A6-EAE3004
5Bombardier CRJN423AW505

Flight

idDepartureTimeArrivalTimeOriginAirportIdDestinationAirportIdAircraftId
(→ Airport.id)(→ Airport.id)(→ Aircraft.id)
12022-01-01 10:00:002022-01-01 13:00:00121
22022-01-01 11:00:002022-01-01 14:00:00212
32022-01-01 12:00:002022-01-01 15:00:00343
42022-01-01 13:00:002022-01-01 16:00:00434
52022-01-01 14:00:002022-01-01 17:00:00525

Maintenance

idDescriptionStartDateEndDateAircraftId
(→ Aircraft.id)
1Engine check2022-01-01 08:00:002022-01-01 12:00:001
2Landing gear inspection2022-01-01 13:00:002022-01-01 17:00:002
3Brake system check2022-01-01 18:00:002022-01-01 22:00:003
4Avionics test2022-01-01 23:00:002022-01-02 03:00:004
5Tire rotation and balance2022-01-02 04:00:002022-01-02 08:00:005