| 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 |