## news

id | source | article | author_id | category_id | publication_id | tag_id
--- | --- | --- | --- | --- | --- | ---
|  |  | (→ authors.id) | (→ categories.id) | (→ publications.id) | (→ tags.id)
1 | Press Release | Britain Is Cutting Taxes Again. Why Now? | 1 | 1 | 1 | 1
2 | Press Release | Global Warming Threatens Coastal Cities. | 2 | 2 | 1 | 1
3 | Interview | Britain Is Cutting Taxes Again. Why Now? | 1 | 1 | 2 | 1
4 | Interview | The Impact of AI on Jobs. | 3 | 3 | 2 | 2

## authors

id | name | bio
--- | --- | ---
1 | John Smith | A renowned journalist.
2 | Jane Doe | An experienced reporter.

## categories

id | title
--- | ---
1 | Politics
2 | Economy

## publications

id | name | location
--- | --- | ---
1 | Daily News | New York City
2 | Financial Times | London

## tags

id | text
--- | ---
1 | #Taxes
2 | #UK