## Roles

id | RoleName | RiskLevel | Experience | Skills
--- | --- | --- | --- | ---
1 | Investigative Journalist | High | 3 | Research, Interviewing
2 | Investigative Journalist | Medium | 2 | Data Analysis, Writing
3 | War Correspondent | High | 5 | Reporting under Fire, First Aid
4 | War Correspondent | Low | 7 | Fluent Multiple Languages, Research

## Articles

id | Title | Content | PublishedDate | AuthorID
--- | --- | --- | --- | ---
|  |  |  | (→ Authors.id)
1 | Article 1 | Content of article 1... | 2021-08-01 | 1
2 | Article 2 | Content of article 2... | 2021-08-02 | 2
3 | Article 3 | Content of article 3... | 2021-08-03 | 1
4 | Article 4 | Content of article 4... | 2021-08-04 | 2
5 | Article 5 | Content of article 5... | 2021-08-05 | 1

## Authors

id | Name | Surname | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | John Doe | Doe | john@example.com | +11234567890
2 | Jane Smith | Smith | janesmith@example.com | +0987654321

## Publications

id | Name | Type
--- | --- | ---
1 | The Times | Newspaper
2 | Financial Times | Business Newspaper
3 | Guardian | News Website
4 | Economist | Magazine
5 | National Geographic | Travel Magazine

## ArticlePublicationAssociations

articleId | publicationId | publishDate
--- | --- | ---
(→ Articles.id) | (→ Publications.id) |
1 | 1 | 2021-08-01
2 | 2 | 2021-08-02
3 | 3 | 2021-08-03
4 | 4 | 2021-08-04
5 | 1 | 2021-08-05