Airports

idnamecitycountry
1Airport1CityACountryX
2Airport2CityBCountryY
3Airport3CityCCountryZ
4Airport4CityDCountryW
5Airport5CityECountryV

Airlines

idnameheadquarter_cityheadquarter_country
1Airline1HeadquartersAHQX
2Airline2HeadquartersBHQY
3Airline3HeadquartersCHQZ
4Airline4HeadquartersDHQW
5Airline5HeadquartersEHQV

Planes

idmodellinear_dimensionsweight_restrictionairline_id
(→ Airlines.id)
1PlaneModel1Dimensions110000.01
2PlaneModel2Dimensions220000.02
3PlaneModel3Dimensions330000.03
4PlaneModel4Dimensions440000.04
5PlaneModel5Dimensions550000.05

Runways

idlengthwidthcapacityairport_id
(→ Airports.id)
18000.0100.099991
27000.0150.099982
36000.0120.099973
45000.090.099964
54000.080.099955

Flights

iddeparture_timearrival_timerunway_idplane_model
(→ Runways.id)(→ Planes.model)
12022-01-01 08:00:002022-01-01 10:00:001PlaneModel1
22022-01-02 09:00:002022-01-02 11:00:002PlaneModel2
32022-01-03 10:00:002022-01-03 12:00:003PlaneModel3
42022-01-04 11:00:002022-01-04 13:00:004PlaneModel4
52022-01-05 12:00:002022-01-05 14:00:005PlaneModel5

Passengers

idfullnamepassportflight_id
(→ Flights.id)
1Passenger1Passport11
2Passenger2Passport22
3Passenger3Passport33
4Passenger4Passport44
5Passenger5Passport55