employerID | companyName | location |
---|---|---|
1 | CompanyA | New York |
2 | CompanyB | Los Angeles |
3 | CompanyC | Chicago |
4 | CompanyD | Miami |
5 | CompanyE | Houston |
applicantID | firstName | lastName | phoneNumber | resumePath | |
---|---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +1 (123) 456-7890 | https://www.example.com/resume/johndoe.pdf |
2 | Jane | Smith | jane.smith@example.com | +1 (123) 456-7891 | https://www.example.com/resume/janesmith.pdf |
3 | Alice | Johnson | alice.johnson@example.com | +1 (123) 456-7892 | https://www.example.com/resume/alicejohnson.pdf |
4 | Tom | Williams | tom.williams@example.com | +1 (123) 456-7893 | https://www.example.com/resume/tomwilliams.pdf |
5 | Lucy | Brown | lucy.brown@example.com | +1 (123) 456-7894 | https://www.example.com/resume/lucybrown.pdf |
constructionJobID | jobTitle | jobDescription | requiredSkills | constructionJobType | designSoftware |
---|---|---|---|---|---|
(→ Design_Software_Expertise.softwareName) | |||||
1 | Senior Civil Engineer | Plan, design, and supervise construction projects. | Strong math and communication skills; Knowledge of building codes and regulations. | Civil Engineering | AutoCAD |
2 | Civil Engineer | Plan, design, and supervise construction projects. | Strong math and communication skills; Knowledge of building codes and regulations. | Civil Engineering | Revit |
3 | Senior Architect | Design buildings and spaces, ensuring functionality and aesthetics. | Creative thinking, attention to detail, and knowledge of architectural principles. | Architecture | AutoCAD |
4 | Architect | Design buildings and spaces, ensuring functionality and aesthetics. | Creative thinking, attention to detail, and knowledge of architectural principles. | Architecture | Rhino |
softwareID | softwareName |
---|---|
1 | AutoCAD |
2 | Revit |
3 | Rhino |
4 | SketchUp |
5 | Adobe Illustrator |
employedID | applicantID | constructionJobID | startDate | endDate |
---|---|---|---|---|
(→ Applicants.applicantID) | (→ Construction_Jobs.constructionJobID) | |||
1 | 1 | 1 | 2023-01-15 | 2023-12-31 |
2 | 2 | 2 | 2023-02-15 | 2023-12-31 |
3 | 3 | 3 | 2023-03-15 | 2023-12-31 |
4 | 4 | 4 | 2023-04-15 | 2023-12-31 |
5 | 5 | 5 | 2023-05-15 | 2023-12-31 |