Runways

IDNameLengthWidthConstruction_Date
1R13000.075.02015-08-01
2R22900.060.02020-02-15

Taxiways

IDNameLengthWidthStart_Point_IDEnd_Point_ID
(→ Runways.ID)(→ Runways.ID)
1T11000.050.012
2T21500.070.023

Airplanes

IDModelCapacityArrival_TimeDeparture_TimeCurrent_Location_ID
(→ Taxiways.ID)
1Boeing 7372002022-03-10 10:00:002022-03-10 15:30:001
2Airbus A3201802022-03-11 09:00:002022-03-11 14:30:002

Flights

Flight_NumberPlane_IDOrigin_Airport_IDDestination_Airport_IDDateTimeStatus
(→ Airplanes.ID)(→ Taxiways.ID)(→ Taxiways.ID)
11122022-03-1011:00Departed
22212022-03-1110:00Cancelled

Maintenance_Records

Record_IDPlane_IDDescriptionPerformed_ByCompletion_Date
(→ Airplanes.ID)
11Engine overhaulMechanic John Doe2021-12-15
22Landing gear repairMechanic Jane Smith2021-11-20

Weather_Conditions

Condition_IDLocation_IDTemperatureWind_SpeedPrecipitationVisibility
(→ Taxiways.ID)
1125.010.0Clear10000.0
2230.020.0Foggy8000.0