## Companies

id | name
--- | ---
1 | Airline XYZ
2 | Flying Company ABC
3 | Global Airways
4 | Eagle Airlines
5 | High Sky Carriers

## TrainingCenters

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

## JobPosts

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

## Positions

id | positionTitle
--- | ---
1 | Cabin Crew Member
2 | First Officer
3 | Second Officer
4 | Engineer
5 | Maintenance Technician

## AviationPositions

id | jobPostId | positionId
--- | --- | ---
| (→ JobPosts.id) | (→ Positions.id)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5

## AviationJobRequirements

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.