Editor

idnameemail
1John Doejohn@example.com
2Jane Smithjane@example.com

Articles

idtitlecontentauthor_idreporter_idfinal_draft_id
(→ Authors.author_id)(→ Reporters.reporter_id)(→ Final_Draft.id)
1Breaking News StoryThis is a news story about breaking news.111
2Feature on Local BusinessA feature article about a local business.222

Authors

author_idfirstnamelastname
1AliceBrown
2CharlieGreen

Reporters

reporter_idfirstnamelastname
1DavidBlack
2EvaWhite

Final_Draft

idmanaging_editor_id
(→ Editor.id)
11
22