| OwnerID | Name |
|---|---|
| 1 | Derek Brown |
| 2 | Jane Doe |
| 3 | Mike Smith |
| 4 | Emily Johnson |
| 5 | David Williams |
| 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 |
| 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 |
| 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 |
| 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 |