## Company

id | name | address | phoneNumber | website
--- | --- | --- | --- | ---
1 | Newspaper Co. | 123 Main St | 555-0198 | https://www.newspapercopublishers.com
2 | Broadcast News Inc. | 456 Elm St | 555-0197 | https://www.broadcastnewsinc.net
3 | Digital Media Hub | 789 Oak St | 555-0196 | https://www.digitalmediahubpublishers.org
4 | Print Journalists Network | 101 Pine St | 555-0195 | https://www.printjournalistsnetwork.info
5 | Newsroom Professionals Association | 202 Fir St | 555-0194 | https://www.newsroomprofessionalsassociation.biz

## Location

id | city | state | country | zipCode
--- | --- | --- | --- | ---
1 | New York | NY | USA | 10001
2 | Los Angeles | CA | USA | 90001
3 | London | England | UK | W1A 1AA
4 | Paris | Île-de-France | France | 75001
5 | Tokyo | Japan | JP | 100-0001

## Skills

id | skillName
--- | ---
1 | Communication
2 | Writing
3 | Editing
4 | Research
5 | Marketing

## JobPosting

id | title | description | mediaCareer | languages | startDate | endDate | companyId | locationId
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  |  | (→ Company.id) | (→ Location.id)
1 | Senior Journalist | Experienced journalist required | Journalist | English and Spanish | 2022-01-01 | 2022-12-31 | 1 | 1
2 | Freelance Journalist | Contributor needed for part-time work | Journalist | Italian | 2022-01-01 | 2022-12-31 | 2 | 2
3 | Chief Editor | Looking for a seasoned editor | Editor | English and Spanish | 2022-01-01 | 2022-12-31 | 3 | 3
4 | Sub-editor | Assistant editor role available | Editor | German | 2022-01-01 | 2022-12-31 | 4 | 4
5 | Multimedia Designer | Design skills required | Graphic Designer | Portuguese | 2022-01-01 | 2022-12-31 | 5 | 5
6 | Content Writer | Need someone to write news articles | Writer | None specified | 2022-01-01 | 2022-12-31 | 1 | 1
7 | Photographer | Capturing images for print/online publications | Photographer | French | 2022-01-01 | 2022-12-31 | 2 | 2
8 | Video Producer | Produce video content for online platforms | Videographer | Russian | 2022-01-01 | 2022-12-31 | 3 | 3
9 | Web Developer | Developing websites for various clients | Web Developer | None specified | 2022-01-01 | 2022-12-31 | 4 | 4
10 | Data Analyst | Analyze data for marketing purposes | Analyst | Spanish | 2022-01-01 | 2022-12-31 | 5 | 5