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 |