| id | company_name | address |
|---|---|---|
| 1 | Company A | 123 Main St |
| 2 | Company B | 456 Elm St |
| 3 | Company C | 789 Oak St |
| 4 | Company D | 001 Pine St |
| 5 | Company E | 999 Maple Ave |
| role_id | role_value |
|---|---|
| 1 | Site Supervisor |
| 2 | Project Manager |
| 3 | Estimator |
| 4 | Foreman |
| 5 | Laborer |
| construction_company_id | building_role_id |
|---|---|
| (→ Construction_Companies.id) | (→ Building_Roles.role_id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 4 |