| employerID | companyName | location |
|---|---|---|
| 1 | CompanyA | New York |
| 2 | CompanyB | Los Angeles |
| 3 | CompanyC | Chicago |
| 4 | CompanyD | Miami |
| 5 | CompanyE | Houston |
| jobID | title | description | salary | postedDate | employerID |
|---|---|---|---|---|---|
| (→ Employers.employeeID) | |||||
| 1 | Software Developer | Develop and maintain web applications. | 80000.0 | 2023-01-01 | 1 |
| 2 | Data Analyst | Analyze data and provide insights. | 60000.0 | 2023-01-02 | 2 |
| 3 | Project Manager | Manage project scope, timeline, and resources. | 70000.0 | 2023-01-03 | 3 |
| 4 | Graphic Designer | Create visual content for marketing campaigns. | 50000.0 | 2023-01-04 | 4 |
| 5 | Product Manager | Lead product development from conception to launch. | 90000.0 | 2023-01-05 | 5 |
| 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 |
| applicationID | jobID | applicantID | applicationDate | status |
|---|---|---|---|---|
| (→ JobPostings.jobID) | (→ Applicants.applicantID) | |||
| 1 | 1 | 1 | 2023-01-06 | Pending |
| 2 | 2 | 2 | 2023-01-07 | Accepted |
| 3 | 3 | 3 | 2023-01-08 | Rejected |
| 4 | 4 | 4 | 2023-01-09 | Interview Scheduled |
| 5 | 5 | 5 | 2023-01-10 | Offered |
| constructionJobID | jobTitle | jobDescription | requiredSkills | constructionJobType | designSoftware |
|---|---|---|---|---|---|
| (→ Design_Software_Expertise.softwareName) | |||||
| 1 | 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 | 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 |