Construction_Companies

idcompany_nameaddress
1Company A123 Main St
2Company B456 Elm St
3Company C789 Oak St
4Company D001 Pine St
5Company E999 Maple Ave

Building_Roles

role_idrole_value
1Site Supervisor
2Project Manager
3Estimator
4Foreman
5Laborer

Construction_Companies_Building_Roles

construction_company_idbuilding_role_id
(→ Construction_Companies.id)(→ Building_Roles.role_id)
11
21
31
41
51
54