| id | name | |
|---|---|---|
| 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 |
| 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 |
| skillName | level |
|---|---|
| Python | Intermediate |
| JavaScript | Advanced |
| SQL | Proficient |
| HTML/CSS | Beginner |
| C++ | Expert |
| employeeId | skillName | proficiencyLevel |
|---|---|---|
| (→ Employees.id) | (→ Skills.skillName) | |
| 1 | Python | Intermediate |
| 2 | JavaScript | Advanced |
| 3 | SQL | Proficient |
| 4 | HTML/CSS | Beginner |
| 5 | C++ | Expert |
| employeeId | designSoftware |
|---|---|
| (→ Employees.id) | (→ DesignSoftwareExpertises.softwareName) |
| 1 | AutoCAD |
| 2 | Revit |
| employeeId | designSoftware |
|---|---|
| (→ Employees.id) | (→ DesignSoftwareExpertises.softwareName) |
| 3 | AutoCAD |
| 4 | Rhino |
| 5 | SketchUp |
| 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. |