id | method |
---|---|
1 | Press Conference |
2 | Interview |
id | type |
---|---|
1 | Politician |
2 | Business Leader |
3 | Activist |
article_id | title | content | date | author_id | information_gathering_method_id | participant_type_id |
---|---|---|---|---|---|---|
(→ Author.author_id) | (→ Information_Gathering_Method.id) | (→ Participant_Type.id) | ||||
1 | First Press Conference | Details about the press conference... | 2023-01-01 | 1 | 1 | 1 |
2 | Second Press Conference | Details about the press conference... | 2023-01-02 | 2 | 1 | 2 |
3 | Interview with Politician | Details about the interview... | 2023-01-03 | 3 | 2 | 1 |
4 | Interview with Activist | Details about the activist interview... | 2023-01-04 | 4 | 2 | 2 |
source_id | name | url |
---|---|---|
1 | Official Government Website | https://www.govsite.com/ |
2 | Company Blog | https://blog.company.com/ |
3 | News Channel | https://newschannel.tv/ |
4 | Alternative Media Outlet | https://alternativemedia.org/ |
article_source_id | news_article_id | source_id |
---|---|---|
(→ News_Article.article_id) | (→ Source.source_id) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
quote_id | text | start_time | end_time | news_article_id | speaker_id |
---|---|---|---|---|---|
(→ News_Article.article_id) | (→ Speaker.speaker_id) | ||||
1 | Quote from politician at first press conference. | 00:00:05 | 00:00:15 | 1 | 1 |
2 | Quote from business leader at second press conference. | 00:00:06 | 00:00:17 | 2 | 2 |
3 | Quote from politician during the interview. | 00:00:08 | 00:00:19 | 3 | 3 |
4 | Quote from activist during the interview. | 00:00:09 | 00:00:21 | 4 | 4 |
speaker_id | name | role |
---|---|---|
1 | John Doe | Politician |
2 | Jane Smith | Business Leader |
3 | Bob Johnson | Politician |
4 | Emma Brown | Activist |