Airlines

idname
1AA
2DL
3UA

Airports

idname
1JFK
2LAX
3ORD

Pilots

idairline_idyears_of_experiencerole
(→ Airlines.id)
1110Pilot
223None
337Co-Pilot
449Instructor
556Trainee
6110Aviation Maintenance Technician
728Aviation Maintenance Technician
8110Flight Attendant
927Flight Attendant

Planes

idmodelregistration_numbercurrent_location_id
(→ Airports.id)
1Boeing 787N1234E1
2Airbus A320N1235D2
3Embraer E190N1236D3
4Bombardier Q400N1237C4
5De Havilland Canada DHC-8N1238G5

Flights

idplane_iddeparture_timearrival_timedestination_idorigin_idpilot_id
(→ Planes.id)(→ Airports.id)(→ Airports.id)(→ Pilots.id)
112023-01-01 10:00:002023-01-01 12:00:00211
222023-01-02 11:00:002023-01-02 13:00:00322
332023-01-03 12:00:002023-01-03 14:00:00433
442023-01-04 13:00:002023-01-04 15:00:00544
552023-01-05 14:00:002023-01-05 16:00:00155