## Journalists

id | name | email
--- | --- | ---
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

## Publications

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

## Articles

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

## Investigative_Reports

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

## Elements

element_id | element_value
--- | ---
1 | Interviews
2 | Documents
3 | Photos
4 | Videos
5 | Witness Testimonies

## Investigative_Reports_Elements

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