id | news_source_type |
---|---|
1 | Press Release |
2 | Interview |
id | source_name | news_source_type_id |
---|---|---|
(→ NewsSourceType.id) | ||
1 | Company A | 1 |
2 | Journalist B | 2 |
3 | Newspaper C | 1 |
4 | Radio Station X | 2 |
5 | TV Channel Y | 1 |
id | title |
---|---|
1 | Britain Is Cutting Taxes Again. Why Now? |
2 | Economic Growth Projections for Next Year |
3 | Government Budget Outlook |
4 | Impact of Recent Tax Cuts on Businesses |
5 | Inflation Rate Forecasts |
source_id | article_id | published_date |
---|---|---|
(→ Source.id) | (→ Article.id) | |
1 | 1 | 2023-01-01 08:00:00 |
2 | 1 | 2023-01-01 10:00:00 |
3 | 2 | 2023-01-02 09:00:00 |
4 | 3 | 2023-01-03 07:00:00 |
5 | 4 | 2023-01-04 16:00:00 |
id | name |
---|---|
1 | Author A |
2 | Author B |
3 | Author C |
4 | Author D |
5 | Author E |
writer_id | article_id |
---|---|
(→ Writer.id) | (→ Article.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |