Companies

idname
1Airline XYZ
2Flying Company ABC
3Global Airways
4Eagle Airlines
5High Sky Carriers

TrainingCenters

idcenterNamelocation
1Aviation AcademNew York
2Bird Flight SchoolLos Angeles
3Skies InstituteChicago
4Wind Tunnel AcademyMiami
5Cloud CollegeDallas

JobPosts

idtitledescriptioncompanyIdtrainingCenterId
(→ Companies.id)(→ TrainingCenters.id)
1Flight AttendantBe a friendly face in the sky!11
2Flight AttendantJoin our team of skilled professionals.23
3PilotTake control of the skies!11
4PilotExperience required to soar high.24
5MechanicKeep our fleet flying smoothly.32
6Reservation AgentAssist customers with their travel plans.41

Positions

idpositionTitle
1Cabin Crew Member
2First Officer
3Second Officer
4Engineer
5Maintenance Technician

AviationPositions

idjobPostIdpositionId
(→ JobPosts.id)(→ Positions.id)
111
222
333
444
555

AviationJobRequirements

idaviationPositionIdrequirement
(→ AviationPositions.id)
11Must have valid passport.
21Ability to speak multiple languages.
32Minimum 1000 hours flight time.
42Instrument rating required.
53ATPL license needed.
63Type rating for specific aircraft.
74Experience in maintenance operations.
84Knowledge of FAA regulations.
95Strong technical skills.
105Proficient in using diagnostic tools.