Reporters

reporterIDfullNameemailAddressphoneNumberrole
1John Doejohndoe@example.com123-456-7890Reporter
2Jane Smithjanesmith@example.com098-765-4321Photographer

NewsArticles

articleIDtitlecontentpublishedDateassignedTo
(→ Reporters.reporterID)
1Breaking News StoryThis is a breaking news story...2021-04-011
2Featured Photo EssayA captivating photo essay about...2021-04-022

Deadlines

deadlineIDdeadlineDate
12021-04-25
22021-04-26

ArticleDeadlines

articleDeadlineIDnewsArticleIDdeadlineID
(→ NewsArticles.articleID)(→ Deadlines.deadlineID)
111
222
312
421