Employers

employerIDcompanyNamelocation
1CompanyANew York
2CompanyBLos Angeles
3CompanyCChicago
4CompanyDMiami
5CompanyEHouston

JobPostings

jobIDtitledescriptionsalarypostedDateemployerID
(→ Employers.employeeID)
1Software DeveloperDevelop and maintain web applications.80000.02023-01-011
2Data AnalystAnalyze data and provide insights.60000.02023-01-022
3Project ManagerManage project scope, timeline, and resources.70000.02023-01-033
4Graphic DesignerCreate visual content for marketing campaigns.50000.02023-01-044
5Product ManagerLead product development from conception to launch.90000.02023-01-055

Applicants

applicantIDfirstNamelastNameemailphoneNumberresumePath
1JohnDoejohn.doe@example.com+1 (123) 456-7890https://www.example.com/resume/johndoe.pdf
2JaneSmithjane.smith@example.com+1 (123) 456-7891https://www.example.com/resume/janesmith.pdf
3AliceJohnsonalice.johnson@example.com+1 (123) 456-7892https://www.example.com/resume/alicejohnson.pdf
4TomWilliamstom.williams@example.com+1 (123) 456-7893https://www.example.com/resume/tomwilliams.pdf
5LucyBrownlucy.brown@example.com+1 (123) 456-7894https://www.example.com/resume/lucybrown.pdf

JobApplications

applicationIDjobIDapplicantIDapplicationDatestatus
(→ JobPostings.jobID)(→ Applicants.applicantID)
1112023-01-06Pending
2222023-01-07Accepted
3332023-01-08Rejected
4442023-01-09Interview Scheduled
5552023-01-10Offered

Construction_Jobs

constructionJobIDjobTitlejobDescriptionrequiredSkillsconstructionJobTypedesignSoftware
(→ Design_Software_Expertise.softwareName)
1Civil EngineerPlan, design, and supervise construction projects.Strong math and communication skills; Knowledge of building codes and regulations.Civil EngineeringAutoCAD
2Civil EngineerPlan, design, and supervise construction projects.Strong math and communication skills; Knowledge of building codes and regulations.Civil EngineeringRevit
3ArchitectDesign buildings and spaces, ensuring functionality and aesthetics.Creative thinking, attention to detail, and knowledge of architectural principles.ArchitectureAutoCAD
4ArchitectDesign buildings and spaces, ensuring functionality and aesthetics.Creative thinking, attention to detail, and knowledge of architectural principles.ArchitectureRhino

Design_Software_Expertise

softwareIDsoftwareName
1AutoCAD
2Revit
3Rhino
4SketchUp
5Adobe Illustrator

Employed_in_Construction_Jobs

employedIDapplicantIDconstructionJobIDstartDateendDate
(→ Applicants.applicantID)(→ Construction_Jobs.constructionJobID)
1112023-01-152023-12-31
2222023-02-152023-12-31
3332023-03-152023-12-31
4442023-04-152023-12-31
5552023-05-152023-12-31