Participants

idNamePositionContactInfoInformation_Gathering_MethodParticipant_Type
1John DoeJournalistjohndoe@example.comPress ConferenceReporter
2Jane SmithActivistjanesmith@example.comPress ConferenceNon-politician
3Alice BrownPoliticianalicebrown@example.comInterviewPolitician
4Bob JohnsonExpertbobjohnson@example.comInterviewNon-politician

Articles

idTitleContentPublishDateAuthorId
(→ Authors.id)
1Election ResultsThe election results have been announced...2024-03-07 23:53:271
2Environmental Policy ChangesRecent changes in environmental policy...2024-03-07 23:53:272

Authors

idFullNameContactInfo
1Michael Whitemwhite@example.com
2Emily Greenegreen@example.com

Sources

idSourceNameTypeOfSourceURL
1New York TimesNewspaperhttps://www.nytimes.com/
2CNNNews Networkhttps://edition.cnn.com/

ArticleSources

idArticleIdSourceId
(→ Articles.id)(→ Sources.id)
111
222