Companies
id | name |
1 | Company A |
2 | Company B |
3 | Company C |
4 | Company D |
5 | Company E |
Technologies
id | career_title |
1 | Software Developer |
2 | Data Analyst |
3 | Product Manager |
4 | UX Designer |
5 | QA Engineer |
Grades
id | grade |
1 | Junior |
2 | Middle |
3 | Senior |
4 | Lead |
5 | Principal |
Skills
id | skill_name |
1 | Python |
2 | JavaScript |
3 | SQL |
4 | React |
5 | Angular |
JobPostings
id | title | company_id | technology_id | grade_id |
| | (→ Companies.id) | (→ Technologies.id) | (→ Grades.id) |
1 | Software Developer | 1 | 1 | 2 |
2 | Software Developer | 2 | 3 | 1 |
3 | Data Analyst | 3 | 4 | 3 |
4 | Data Analyst | 4 | 5 | 2 |
5 | Product Manager | 1 | 6 | 4 |
6 | UX Designer | 2 | 7 | 1 |
7 | QA Engineer | 3 | 8 | 3 |
RequiredSkills
jobposting_id | skill_id |
(→ JobPostings.id) | (→ Skills.id) |
1 | 1 |
1 | 2 |
2 | 3 |
2 | 4 |
3 | 5 |
3 | 6 |
4 | 7 |
4 | 8 |
5 | 9 |
5 | 10 |