id | name |
---|---|
1 | Airline XYZ |
2 | Flying Company ABC |
3 | Global Airways |
4 | Eagle Airlines |
5 | High Sky Carriers |
id | centerName | location |
---|---|---|
1 | Aviation Academ | New York |
2 | Bird Flight School | Los Angeles |
3 | Skies Institute | Chicago |
4 | Wind Tunnel Academy | Miami |
5 | Cloud College | Dallas |
id | title | description | companyId | trainingCenterId |
---|---|---|---|---|
(→ Companies.id) | (→ TrainingCenters.id) | |||
1 | Flight Attendant | Be a friendly face in the sky! | 1 | 1 |
2 | Flight Attendant | Join our team of skilled professionals. | 2 | 3 |
3 | Pilot | Take control of the skies! | 1 | 1 |
4 | Pilot | Experience required to soar high. | 2 | 4 |
5 | Mechanic | Keep our fleet flying smoothly. | 3 | 2 |
6 | Reservation Agent | Assist customers with their travel plans. | 4 | 1 |
id | positionTitle |
---|---|
1 | Cabin Crew Member |
2 | First Officer |
3 | Second Officer |
4 | Engineer |
5 | Maintenance Technician |
id | jobPostId | positionId |
---|---|---|
(→ JobPosts.id) | (→ Positions.id) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
id | aviationPositionId | requirement |
---|---|---|
(→ AviationPositions.id) | ||
1 | 1 | Must have valid passport. |
2 | 1 | Ability to speak multiple languages. |
3 | 2 | Minimum 1000 hours flight time. |
4 | 2 | Instrument rating required. |
5 | 3 | ATPL license needed. |
6 | 3 | Type rating for specific aircraft. |
7 | 4 | Experience in maintenance operations. |
8 | 4 | Knowledge of FAA regulations. |
9 | 5 | Strong technical skills. |
10 | 5 | Proficient in using diagnostic tools. |