| id | name | phone | |
|---|---|---|---|
| 1 | John Doe | johndoe@example.com | +1234567890 |
| 2 | Jane Smith | janesmith@example.com | +0987654321 |
| id | name | location | contact_email |
|---|---|---|---|
| 1 | Agencia Noticias | Madrid, Spain | contact@noticias.es |
| 2 | News Hub | New York City, USA | contact@newshub.us |
| 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 |
| id | category_name | description |
|---|---|---|
| 1 | Politics | Stories about government and political activities. |
| 2 | Economy | Articles covering financial matters and economic trends. |
| 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 |