Companies
id | name |
1 | Company A |
2 | Company B |
3 | Company C |
4 | Company D |
5 | Company E |
JobsTypes
id | type |
1 | Software Engineer |
2 | Data Analyst |
3 | Product Manager |
4 | HR Specialist |
5 | Graphic Designer |
Salaries
id | salary |
1 | $65,000 |
2 | $80,000 |
3 | $95,000 |
4 | $100,000 |
5 | $120,000 |
JobPostings
id | companyID | jobTypeID | itJob | salaryID |
| (→ Companies.id) | (→ JobsTypes.id) | | (→ Salaries.id) |
1 | 1 | 1 | Network Administrator | 3 |
2 | 1 | 1 | Network Administrator | 1 |
3 | 2 | 2 | IT Consultant | 3 |
4 | 2 | 2 | IT Consultant | 1 |
5 | 3 | 3 | Software Developer | 2 |
6 | 3 | 3 | Software Developer | 4 |
7 | 4 | 4 | HR Coordinator | 5 |
8 | 4 | 4 | HR Coordinator | 2 |
9 | 5 | 5 | Web Designer | 4 |
10 | 5 | 5 | Web Designer | 3 |