| 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 |
| 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 |
| id | Name | Surname | PhoneNumber | |
|---|---|---|---|---|
| 1 | John Doe | Doe | john@example.com | +11234567890 |
| 2 | Jane Smith | Smith | janesmith@example.com | +0987654321 |
| id | Name | Type |
|---|---|---|
| 1 | The Times | Newspaper |
| 2 | Financial Times | Business Newspaper |
| 3 | Guardian | News Website |
| 4 | Economist | Magazine |
| 5 | National Geographic | Travel Magazine |
| 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 |