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