## Employers

employerID | companyName | location
--- | --- | ---
1 | CompanyA | New York
2 | CompanyB | Los Angeles
3 | CompanyC | Chicago
4 | CompanyD | Miami
5 | CompanyE | Houston

## JobPostings

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

## Applicants

applicantID | firstName | lastName | email | 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

## JobApplications

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

## Construction_Jobs

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

## Design_Software_Expertise

softwareID | softwareName
--- | ---
1 | AutoCAD
2 | Revit
3 | Rhino
4 | SketchUp
5 | Adobe Illustrator

## Employed_in_Construction_Jobs

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