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 |