id | name | location |
---|---|---|
1 | Mountain View | |
2 | Menlo Park | |
3 | Amazon | Seattle |
4 | Apple | Cupertino |
5 | Microsoft | Redmond |
id | title | description | salary |
---|---|---|---|
1 | Software Developer | Develop software applications. | 80000.0 |
2 | Web Designer | Design websites and user interfaces. | 60000.0 |
3 | System Administrator | Maintain computer systems and networks. | 70000.0 |
4 | Database Analyst | Analyze data and provide insights. | 90000.0 |
5 | Project Manager | Manage projects and resources. | 100000.0 |
id | skillName |
---|---|
1 | Python |
2 | JavaScript |
3 | SQL |
4 | PHP |
5 | Ruby |
id | role | programmingSkills | companyId | positionId | skillId |
---|---|---|---|---|---|
(→ Company.id) | (→ Position.id) | (→ Skill.id) | |||
1 | Software Engineer | Python | 1 | 1 | 1 |
2 | Software Engineer | JavaScript | 2 | 1 | 3 |
3 | Data Scientist | Python | 3 | 2 | 1 |
4 | Data Scientist | R | 4 | 3 | 5 |