## Companies

id | name | location_id
--- | --- | ---
|  | (→ Locations.id)
1 | Company A | 1
2 | Company B | 2
3 | Company C | 3
4 | Company D | 4
5 | Company E | 5

## Locations

id | city | state | country
--- | --- | --- | ---
1 | New York | NY | USA
2 | Los Angeles | CA | USA
3 | Chicago | IL | USA
4 | Houston | TX | USA
5 | Toronto | ON | Canada

## Qualifications

id | requirement
--- | ---
1 | Bachelor's degree in Civil Engineering
2 | Experience with Revit software
3 | Proficiency in AutoCAD software
4 | Strong communication skills
5 | Ability to work under pressure

## JobPostings

id | title | company_id | construction_job | design_software_expertise | years_of_experience | salary_range | qualification_id
--- | --- | --- | --- | --- | --- | --- | ---
|  | (→ Companies.id) |  |  |  |  | (→ Qualifications.id)
1 | Civil Engineer | 1 | 1 | AutoCAD | 5 | $60k-$70k | 1
2 | Civil Engineer | 1 | 1 | SketchUp | 4 | $55k-$65k | 2
3 | Architect | 2 | 0 | AutoCAD | 8 | $75k-$85k | 3
4 | Architect | 2 | 0 | Rhino + Grasshopper | 6 | $70k-$80k | 4

## Requirements

id | jobposting_id | qualification_id
--- | --- | ---
| (→ JobPostings.id) | (→ Qualifications.id)
1 | 1 | 1
2 | 1 | 2
3 | 2 | 3
4 | 2 | 4