| 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 |