## Company_Owners

OwnerID | Name
--- | ---
1 | Derek Brown
2 | Jane Doe
3 | Mike Smith
4 | Emily Johnson
5 | David Williams

## Construction_Workers

WorkerID | Name | HourlyRate
--- | --- | ---
| (→ Company_Owners.Name) |
1 | Derek Brown | 20.0
2 | John Adams | 22.0
3 | Robert Lee | 21.0
4 | James Baker | 23.0
5 | Thomas Jefferson | 24.0

## Electricians

ElectricianID | Name | ExperienceYears
--- | --- | ---
| (→ Company_Owners.Name) |
1 | Derek Brown | 7
2 | Jane Doe | 5
3 | Mike Smith | 8
4 | Emily Johnson | 6
5 | David Williams | 9

## Jobs

JobID | JobTitle | Description | Location | DatePosted | Status
--- | --- | --- | --- | --- | ---
| (→ Construction_Workers.Name) |  |  |  |
1 | Construction Worker | Building houses and infrastructure. | New York | 2024-03-13 19:47:31 | Open
2 | Electrician | Installing electrical systems in residential and commercial buildings. | Los Angeles | 2024-03-13 19:47:31 | Open
3 | Construction Worker | Constructing roads, bridges, and other public works. | Chicago | 2024-03-13 19:47:31 | Filled
4 | Electrician | Designing and installing electrical systems for industrial facilities. | Houston | 2024-03-13 19:47:31 | Filled
5 | Construction Worker | Specializing in concrete work for construction projects. | Phoenix | 2024-03-13 19:47:31 | Open

## Applicants

ApplicationID | FullName | EmailAddress | ResumePath | JobID
--- | --- | --- | --- | ---
|  |  |  | (→ Jobs.JobID)
1 | Alice Cooper | alice@example.com | /resume/alice_cooper.pdf | 1
2 | Bob Marley | bob@example.com | /resume/bob_marley.pdf | 1
3 | Carol King | carol@example.com | /resume/carol_king.pdf | 2
4 | Daniel Craig | daniel@example.com | /resume/daniel_craig.pdf | 3
5 | Elizabeth Taylor | elizabeth@example.com | /resume/elizabeth_taylor.pdf | 4