| 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 |
| 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 |
| 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 |
| 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 |
| id | jobposting_id | qualification_id |
|---|---|---|
| (→ JobPostings.id) | (→ Qualifications.id) | |
| 1 | 1 | 1 |
| 2 | 1 | 2 |
| 3 | 2 | 3 |
| 4 | 2 | 4 |