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 |