| id | name | phone | |
|---|---|---|---|
| 1 | John Doe | johndoe@example.com | +1234567890 |
| 2 | Jane Smith | janesmith@example.com | +0987654321 |
| 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 |
| id | title | content | publish_date | Reporter |
|---|---|---|---|---|
| (→ journalists.id) | ||||
| 1 | US Election Results | This is an article about recent election results. | 2024-02-19 15:13:19 | 1 |
| 2 | European Economy Overview | An overview of European economies. | 2024-02-19 15:13:19 | 2 |