Company_Owners

OwnerIDName
1Derek Brown
2Jane Doe
3Mike Smith
4Emily Johnson
5David Williams

Construction_Workers

WorkerIDNameHourlyRate
(→ Company_Owners.Name)
1Derek Brown20.0
2John Adams22.0
3Robert Lee21.0
4James Baker23.0
5Thomas Jefferson24.0

Electricians

ElectricianIDNameExperienceYears
(→ Company_Owners.Name)
1Derek Brown7
2Jane Doe5
3Mike Smith8
4Emily Johnson6
5David Williams9

Jobs

JobIDJobTitleDescriptionLocationDatePostedStatus
(→ Construction_Workers.Name)
1Construction WorkerBuilding houses and infrastructure.New York2024-03-13 19:47:31Open
2ElectricianInstalling electrical systems in residential and commercial buildings.Los Angeles2024-03-13 19:47:31Open
3Construction WorkerConstructing roads, bridges, and other public works.Chicago2024-03-13 19:47:31Filled
4ElectricianDesigning and installing electrical systems for industrial facilities.Houston2024-03-13 19:47:31Filled
5Construction WorkerSpecializing in concrete work for construction projects.Phoenix2024-03-13 19:47:31Open

Applicants

ApplicationIDFullNameEmailAddressResumePathJobID
(→ Jobs.JobID)
1Alice Cooperalice@example.com/resume/alice_cooper.pdf1
2Bob Marleybob@example.com/resume/bob_marley.pdf1
3Carol Kingcarol@example.com/resume/carol_king.pdf2
4Daniel Craigdaniel@example.com/resume/daniel_craig.pdf3
5Elizabeth Taylorelizabeth@example.com/resume/elizabeth_taylor.pdf4