## Companies

id | companyName
--- | ---
1 | Company A
2 | Company B
3 | Company C
4 | Company D
5 | Company E

## Locations

id | locationName
--- | ---
1 | Location 1
2 | Location 2
3 | Location 3
4 | Location 4
5 | Location 5

## JobTitles

id | title
--- | ---
1 | Software Developer
2 | Data Scientist
3 | Product Manager
4 | UX Designer
5 | QA Engineer

## JobPosts

jobId | managementRole | projectDurationEstimate | salaryRange | companyID | locationID | jobTitleID
--- | --- | --- | --- | --- | --- | ---
|  |  |  | (→ Companies.id) | (→ Locations.id) | (→ JobTitles.id)
1 | Project Manager | 4 weeks | 60k - 80k | 1 | 1 | 1
2 | Project Manager | 8 weeks | 70k - 90k | 2 | 2 | 1
3 | Business Analyst | 4 weeks | 50k - 70k | 3 | 3 | 2
4 | Business Analyst | 6 weeks | 60k - 80k | 4 | 4 | 2
5 | Development Lead | 2 months | 90k - 110k | 1 | 1 | 3
6 | Design Team Leader | 3 months | 80k - 100k | 2 | 2 | 4
7 | Product Owner | 2 years | 100k - 120k | 3 | 3 | 1
8 | UI/UX Architect | 1 year | 80k - 100k | 4 | 4 | 5
9 | Quality Assurance Specialist | 1 month | 40k - 60k | 5 | 5 | 6