| id | Name | Position | ContactInfo | Information_Gathering_Method | Participant_Type |
|---|---|---|---|---|---|
| 1 | John Doe | Journalist | johndoe@example.com | Press Conference | Reporter |
| 2 | Jane Smith | Activist | janesmith@example.com | Press Conference | Non-politician |
| 3 | Alice Brown | Politician | alicebrown@example.com | Interview | Politician |
| 4 | Bob Johnson | Expert | bobjohnson@example.com | Interview | Non-politician |
| id | Title | Content | PublishDate | AuthorId |
|---|---|---|---|---|
| (→ Authors.id) | ||||
| 1 | Election Results | The election results have been announced... | 2024-03-07 23:53:27 | 1 |
| 2 | Environmental Policy Changes | Recent changes in environmental policy... | 2024-03-07 23:53:27 | 2 |
| id | FullName | ContactInfo |
|---|---|---|
| 1 | Michael White | mwhite@example.com |
| 2 | Emily Green | egreen@example.com |
| id | SourceName | TypeOfSource | URL |
|---|---|---|---|
| 1 | New York Times | Newspaper | https://www.nytimes.com/ |
| 2 | CNN | News Network | https://edition.cnn.com/ |
| id | ArticleId | SourceId |
|---|---|---|
| (→ Articles.id) | (→ Sources.id) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |