journalists

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

news_agencies

idnamelocationcontact_email
1Agencia NoticiasMadrid, Spaincontact@noticias.es
2News HubNew York City, USAcontact@newshub.us

stories

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

story_categories

idcategory_namedescription
1PoliticsStories about government and political activities.
2EconomyArticles covering financial matters and economic trends.

assigned_stories

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