## journalists

id | name | email | phone
--- | --- | --- | ---
1 | John Doe | johndoe@example.com | +1234567890
2 | Jane Smith | janesmith@example.com | +0987654321

## news_agencies

id | name | location | contact_email
--- | --- | --- | ---
1 | Agencia Noticias | Madrid, Spain | contact@noticias.es
2 | News Hub | New York City, USA | contact@newshub.us

## stories

id | title | content | publish_date | journalist_id | news_agency_id
--- | --- | --- | --- | --- | ---
|  |  |  | (→ journalists.id) | (→ news_agencies.id)
1 | US Election Results | This is an article about recent election results. | 2024-02-19 15:13:19 | 1 | 1
2 | European Economy Overview | An overview of European economies. | 2024-02-19 15:13:19 | 2 | 2

## story_categories

id | category_name | description
--- | --- | ---
1 | Politics | Stories about government and political activities.
2 | Economy | Articles covering financial matters and economic trends.

## assigned_stories

id | story_id | journalist_id | start_date | end_date
--- | --- | --- | --- | ---
| (→ stories.id) | (→ journalists.id) |  |
1 | 1 | 1 | 2022-09-01 | 2022-09-15
2 | 2 | 2 | 2022-09-02 | 2022-09-16