journalists

idnameemailphone
1John Doejohndoe@example.com+1234567890
2Jane Smithjanesmith@example.com+0987654321

assigned_stories

idstory_idjournalist_idstart_dateend_date
(→ stories.id)(→ journalists.id)
1112022-09-012022-09-15
2222022-09-022022-09-16

stories

idtitlecontentpublish_dateReporter
(→ journalists.id)
1US Election ResultsThis is an article about recent election results.2024-02-19 15:13:191
2European Economy OverviewAn overview of European economies.2024-02-19 15:13:192