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