Company
id | name |
1 | Company1 |
2 | Company2 |
3 | Company3 |
4 | Company4 |
5 | Company5 |
Position
id | title | salary |
(→ Company.id) | | |
1 | Position1 | 60000.0 |
2 | Position2 | 70000.0 |
3 | Position3 | 80000.0 |
4 | Position4 | 90000.0 |
5 | Position5 | 100000.0 |
SalesAssociates
id | position_id | target_market_id | skills | experience |
| (→ Position.id) | (→ TargetMarket.id) | | |
1 | 1 | 1 | Skill1 | 2 |
2 | 1 | 2 | Skill2 | 3 |
3 | 2 | 1 | Skill3 | 4 |
4 | 2 | 2 | Skill4 | 5 |
5 | 3 | 1 | Skill5 | 6 |
6 | 3 | 2 | Skill6 | 7 |
MarketingSpecialists
id | position_id | target_market_id | skills | experience |
| (→ Position.id) | (→ TargetMarket.id) | | |
1 | 4 | 1 | Skill7 | 8 |
2 | 4 | 2 | Skill8 | 9 |
3 | 5 | 1 | Skill9 | 10 |
4 | 5 | 2 | Skill10 | 11 |