| 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 |