## Employees

id | name | email
--- | --- | ---
1 | John Doe | john@example.com
2 | Jane Smith | jane@example.com
3 | Michael Brown | michael@example.com
4 | Emily Davis | emily@example.com
5 | David Johnson | david@example.com

## JobPosts

id | title | description | postedOn | positionType
--- | --- | --- | --- | ---
1 | Civil Engineer | Looking for a skilled civil engineer... | 2023-01-01 | Full Time
2 | Architect | Seeking an experienced architect for our team... | 2023-01-15 | Part Time
3 | Project Manager | We need a project manager for our upcoming projects... | 2023-01-30 | Contract
4 | Software Developer | A software developer is needed for our growing tech company... | 2023-02-01 | Full Time
5 | Marketing Specialist | A marketing specialist is required for our new product launch... | 2023-02-15 | Contract

## Skills

skillName | level
--- | ---
Python | Intermediate
JavaScript | Advanced
SQL | Proficient
HTML/CSS | Beginner
C++ | Expert

## EmployeeSkills

employeeId | skillName | proficiencyLevel
--- | --- | ---
(→ Employees.id) | (→ Skills.skillName) |
1 | Python | Intermediate
2 | JavaScript | Advanced
3 | SQL | Proficient
4 | HTML/CSS | Beginner
5 | C++ | Expert

## CivilEngineers

employeeId | designSoftware
--- | ---
(→ Employees.id) | (→ DesignSoftwareExpertises.softwareName)
1 | AutoCAD
2 | Revit

## Architects

employeeId | designSoftware
--- | ---
(→ Employees.id) | (→ DesignSoftwareExpertises.softwareName)
3 | AutoCAD
4 | Rhino
5 | SketchUp

## DesignSoftwareExpertises

softwareName | expertiseDescription
--- | ---
AutoCAD | Experienced in AutoCAD for building and infrastructure designs.
Revit | Proficient in Revit for BIM modeling and construction documentation.
Rhino | Skilled in Rhino for complex geometric forms and parametric modeling.
SketchUp | Familiarity with SketchUp for rapid prototyping and conceptual design.