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 |