Roles

idRoleNameRiskLevelExperienceSkills
1Investigative JournalistHigh3Research, Interviewing
2Investigative JournalistMedium2Data Analysis, Writing
3War CorrespondentHigh5Reporting under Fire, First Aid
4War CorrespondentLow7Fluent Multiple Languages, Research

Articles

idTitleContentPublishedDateAuthorID
(→ Authors.id)
1Article 1Content of article 1...2021-08-011
2Article 2Content of article 2...2021-08-022
3Article 3Content of article 3...2021-08-031
4Article 4Content of article 4...2021-08-042
5Article 5Content of article 5...2021-08-051

Authors

idNameSurnameEmailPhoneNumber
1John DoeDoejohn@example.com+11234567890
2Jane SmithSmithjanesmith@example.com+0987654321

Publications

idNameType
1The TimesNewspaper
2Financial TimesBusiness Newspaper
3GuardianNews Website
4EconomistMagazine
5National GeographicTravel Magazine

ArticlePublicationAssociations

articleIdpublicationIdpublishDate
(→ Articles.id)(→ Publications.id)
112021-08-01
222021-08-02
332021-08-03
442021-08-04
512021-08-05