Journalists

idnameemail
1John Doejohn@example.com
2Jane Smithjane@example.com
3Michael Johnsonmichael@example.com
4Emily Davisemily@example.com
5William Brownwilliam@example.com

Publications

idtitlepublication_date
1The Daily News2021-01-01
2The Weekly Times2021-01-08
3News Today2021-01-15
4World Report2021-01-22
5Global Insight2021-01-29

Articles

idjournalist_idpublication_idarticle_titlepublish_date
(→ Journalists.id)(→ Publications.id)
111Political Crisis Unfolding2021-01-01
222Economic Recovery Progress2021-01-08
333Climate Change Effects2021-01-15
444Technology Revolution2021-01-22
555Healthcare Innovations2021-01-29

Investigative_Reports

idreport_namestart_dateend_datearticle_id
(→ Articles.id)
1Corruption Scandal2021-01-012021-01-311
2Illegal Drug Trade2021-01-012021-01-312
3Tax Evasion Schemes2021-01-012021-01-313
4Financial Fraud2021-01-012021-01-314
5Cybercrime Surge2021-01-012021-01-315

Elements

element_idelement_value
1Interviews
2Documents
3Photos
4Videos
5Witness Testimonies

Investigative_Reports_Elements

idinvestigative_report_idelement_iddescription
(→ Investigative_Reports.id)(→ Elements.elements_id)
111Conducted interviews with key witnesses
222Obtained confidential documents from a whistleblower
333Collected photos at crime scenes
444Recorded videos of protestors during the investigation
555Gathered testimonies from eyewitnesses
621Obtained confidential documents from a whistleblower
731Collected photos at crime scenes
841Recorded videos of protestors during the investigation
951Gathered testimonies from eyewitnesses