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 |