Information_Gathering_Method

idmethod
1Press Conference
2Interview

Participant_Type

idtype
1Politician
2Business Leader
3Activist

News_Article

article_idtitlecontentdateauthor_idinformation_gathering_method_idparticipant_type_id
(→ Author.author_id)(→ Information_Gathering_Method.id)(→ Participant_Type.id)
1First Press ConferenceDetails about the press conference...2023-01-01111
2Second Press ConferenceDetails about the press conference...2023-01-02212
3Interview with PoliticianDetails about the interview...2023-01-03321
4Interview with ActivistDetails about the activist interview...2023-01-04422

Source

source_idnameurl
1Official Government Websitehttps://www.govsite.com/
2Company Bloghttps://blog.company.com/
3News Channelhttps://newschannel.tv/
4Alternative Media Outlethttps://alternativemedia.org/

Article_Source

article_source_idnews_article_idsource_id
(→ News_Article.article_id)(→ Source.source_id)
111
222
333
444

Quote

quote_idtextstart_timeend_timenews_article_idspeaker_id
(→ News_Article.article_id)(→ Speaker.speaker_id)
1Quote from politician at first press conference.00:00:0500:00:1511
2Quote from business leader at second press conference.00:00:0600:00:1722
3Quote from politician during the interview.00:00:0800:00:1933
4Quote from activist during the interview.00:00:0900:00:2144

Speaker

speaker_idnamerole
1John DoePolitician
2Jane SmithBusiness Leader
3Bob JohnsonPolitician
4Emma BrownActivist