Company
id | name | address |
1 | Company A | 123 Main St |
2 | Company B | 456 Oak St |
3 | Company C | 789 Pine St |
4 | Company D | 098 Maple St |
5 | Company E | 567 Elm St |
Skills
id | skillName |
1 | Photoshop |
2 | Illustrator |
3 | HTML |
4 | CSS |
5 | JavaScript |
Location
id | officeAddress |
1 | 2/7 London Street |
2 | 3/15 New York Ave |
3 | 4/23 Los Angeles Blvd |
4 | 5/4 Chicago Dr |
5 | 6/41 Boston Rd |
JobPosting
id | jobTitle | companyID | skillsID | locationID |
| | (→ Company.id) | (→ Skills.id) | (→ Location.id) |
1 | Graphic Designer | 1 | 1 | 1 |
2 | Graphic Designer | 2 | 2 | 2 |
3 | Web Developer | 1 | 3 | 1 |
4 | Web Developer | 2 | 4 | 3 |
5 | Software Engineer | 3 | 5 | 4 |
6 | Data Analyst | 4 | 6 | 5 |
7 | Project Manager | 5 | 7 | 6 |
Creative_Industry_Professions
id | profession | skillsID |
| | (→ Skills.id) |
1 | Graphic Designer | 1 |
2 | Graphic Designer | 2 |
3 | Web Developer | 3 |
4 | Web Developer | 4 |
5 | UX Designer | 5 |
6 | UI Designer | 6 |
Office
id | officeAddress | locationID |
| | (→ Location.id) |
1 | 2/7 London Street | 1 |
2 | 3/15 New York Ave | 2 |
3 | 4/23 Los Angeles Blvd | 3 |
4 | 5/4 Chicago Dr | 4 |
5 | 6/41 Boston Rd | 5 |