id | name | |
---|---|---|
1 | John Doe | john@example.com |
2 | Jane Smith | jane@example.com |
3 | Michael Johnson | michael@example.com |
4 | Emily Davis | emily@example.com |
5 | William Brown | william@example.com |
id | title | publication_date |
---|---|---|
1 | The Daily News | 2021-01-01 |
2 | The Weekly Times | 2021-01-08 |
3 | News Today | 2021-01-15 |
4 | World Report | 2021-01-22 |
5 | Global Insight | 2021-01-29 |
id | journalist_id | publication_id | article_title | publish_date |
---|---|---|---|---|
(→ Journalists.id) | (→ Publications.id) | |||
1 | 1 | 1 | Political Crisis Unfolding | 2021-01-01 |
2 | 2 | 2 | Economic Recovery Progress | 2021-01-08 |
3 | 3 | 3 | Climate Change Effects | 2021-01-15 |
4 | 4 | 4 | Technology Revolution | 2021-01-22 |
5 | 5 | 5 | Healthcare Innovations | 2021-01-29 |
id | report_name | start_date | end_date | article_id |
---|---|---|---|---|
(→ Articles.id) | ||||
1 | Corruption Scandal | 2021-01-01 | 2021-01-31 | 1 |
2 | Illegal Drug Trade | 2021-01-01 | 2021-01-31 | 2 |
3 | Tax Evasion Schemes | 2021-01-01 | 2021-01-31 | 3 |
4 | Financial Fraud | 2021-01-01 | 2021-01-31 | 4 |
5 | Cybercrime Surge | 2021-01-01 | 2021-01-31 | 5 |
element_id | element_value |
---|---|
1 | Interviews |
2 | Documents |
3 | Photos |
4 | Videos |
5 | Witness Testimonies |
id | investigative_report_id | element_id | description |
---|---|---|---|
(→ Investigative_Reports.id) | (→ Elements.elements_id) | ||
1 | 1 | 1 | Conducted interviews with key witnesses |
2 | 2 | 2 | Obtained confidential documents from a whistleblower |
3 | 3 | 3 | Collected photos at crime scenes |
4 | 4 | 4 | Recorded videos of protestors during the investigation |
5 | 5 | 5 | Gathered testimonies from eyewitnesses |
6 | 2 | 1 | Obtained confidential documents from a whistleblower |
7 | 3 | 1 | Collected photos at crime scenes |
8 | 4 | 1 | Recorded videos of protestors during the investigation |
9 | 5 | 1 | Gathered testimonies from eyewitnesses |