## Role

id | roleName
--- | ---
1 | Software Engineer
2 | Data Scientist
3 | Product Manager
4 | Graphic Designer
5 | Marketing Specialist

## Skill

id | skillName
--- | ---
1 | Python Programming
2 | JavaScript Development
3 | SQL Database Management
4 | User Experience Design
5 | Search Engine Optimization

## Location

id | locationName
--- | ---
1 | New York City
2 | San Francisco
3 | Los Angeles
4 | Chicago
5 | Miami

## JobPosting

jobId | title | description | postDate | customerFacing | language | roleID | skillID | locationID
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Role.id) | (→ Skill.id) | (→ Location.id)
1 | Customer Service Advisor | Assisting customers with their queries and issues. | 2024-03-07 | 1 | Bilingual | 1 | 1 | 1
2 | Customer Service Advisor | Handling customer complaints and providing support. | 2024-03-07 | 0 | English only | 2 | 2 | 2
3 | IT Support Technician | Troubleshooting hardware and software issues. | 2024-03-07 | 1 | Bilingual | 3 | 3 | 3
4 | IT Support Technician | Resolving technical problems and offering solutions. | 2024-03-07 | 0 | English only | 4 | 4 | 4
5 | Senior Software Engineer | Designing and implementing complex software systems. | 2024-03-07 | 0 | Bilingual | 5 | 5 | 5
6 | Digital Marketing Specialist | Developing and executing digital marketing strategies. | 2024-03-07 | 0 | English only | 6 | 6 | 6