id | name |
---|---|
1 | yourcompany1 |
2 | yourcompany2 |
id | company_id | employee_name |
---|---|---|
(→ Company.id) | ||
1 | 1 | Employee of yourcompany1 |
2 | 1 | Another employee of yourcompany1 |
3 | 2 | Employee of yourcompany2 |
id | position_title | trades_jobs | company_id |
---|---|---|---|
(→ Company.id) | |||
1 | Position1 | Construction worker | 1 |
2 | Position2 | Electrician | 1 |
3 | Position3 | Construction worker | 2 |
4 | Position4 | Electrician | 2 |
id | skill_type | position_id |
---|---|---|
(→ Position.id) | ||
1 | Skill1 | Position1 |
2 | Skill2 | Position2 |
3 | Skill3 | Position3 |
4 | Skill4 | Position4 |