## Information_Gathering_Method

id | method
--- | ---
1 | Press Conference
2 | Interview

## Participant_Type

id | type
--- | ---
1 | Politician
2 | Business Leader
3 | Activist

## News_Article

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

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

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

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

speaker_id | name | role
--- | --- | ---
1 | John Doe | Politician
2 | Jane Smith | Business Leader
3 | Bob Johnson | Politician
4 | Emma Brown | Activist