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 |