| 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. |