Airports

idnamecitycountry
1Airport ACity ACountry X
2Airport BCity BCountry Y
3Airport CCity CCountry Z
4Airport DCity DCountry W
5Airport ECity ECountry V

Runways

idairport_idlengthwidth
(→ Airports.id)
113000.045.0
222800.040.0
333200.045.0
442900.042.0
553100.045.0

Terminals

idairport_idcapacity
(→ Airports.id)
1115
2220
3325
4430
5535

Airlines

idnameheadquarters_city
1Company ACity A
2Company BCity B
3Company CCity C
4Company DCity D
5Company ECity E

Flights

flight_numberairline_iddeparture_timearrival_timeorigin_airport_iddestination_airport_idaircraft_type
(→ Airlines.id)(→ Airports.id)(→ Airports.id)
112023-01-01 08:00:002023-01-01 10:00:0012Boeing 737
222023-01-01 09:00:002023-01-01 11:00:0023Airbus A320
332023-01-01 10:00:002023-01-01 12:00:0031Boeing 747
442023-01-01 11:00:002023-01-01 13:00:0045Embraer ERJ 190
552023-01-01 12:00:002023-01-01 14:00:0052Airbus A380

Airport_Staff

staff_idrolesalaryhire_date
(→ Airports.id)
1Air Traffic Controller$60,000 per year2022-01-01
2Air Traffic Controllerother amount2022-02-01
3Ground Staff$60,000 per year2022-01-01
4Ground Staffother amount2022-02-01
5other rolearbitrary amountarbitrary date