| id | name | address | |
|---|---|---|---|
| 1 | Company A | 123 Main St, Anytown, USA | info@companya.com |
| 2 | Company B | 456 Elm St, Othertown, USA | contact@companyb.com |
| id | technologyName |
|---|---|
| 1 | Python |
| 2 | JavaScript |
| 3 | C# |
| 4 | Ruby |
| 5 | Swift |
| id | title | description | companyId | salary | technicalProfession | skillIds | locationId |
|---|---|---|---|---|---|---|---|
| (→ Companies.id) | (→ Technologies.id) | ||||||
| 1 | Software Engineer | Develop software applications using Python. | 1 | 80000 | Engineer | 2,3 | 1 |
| 2 | Senior Software Engineer | Lead a team of engineers and develop complex software systems. | 1 | 95000 | Engineer | 2,3 | 1 |
| 3 | Software Architect | Design and implement high-level architecture for large-scale applications. | 2 | 80000 | Architect | 1,4 | 2 |
| 4 | Principal Software Architect | Define product vision and guide the overall technical direction of the project. | 2 | 105000 | Architect | 1,4 | 2 |
| id | city | country |
|---|---|---|
| 1 | Anytown | USA |
| 2 | Othertown | USA |