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 |