## Managing_Editor

id | name | email
--- | --- | ---
1 | John Doe | john@example.com
2 | Jane Smith | jane@example.com

## Copy_Editor

id | name | email
--- | --- | ---
1 | Mike Johnson | mike@example.com
2 | Emily Davis | emily@example.com

## Final_Draft

id | managing_editor_id | copy_editor_id
--- | --- | ---
| (→ Managing_Editor.id) | (→ Copy_Editor.id)
1 | 1 | 1
2 | 2 | 2

## Articles

id | title | content | author_id | reporter_id | final_draft_id
--- | --- | --- | --- | --- | ---
|  |  | (→ Authors.author_id) | (→ Reporters.reporter_id) | (→ Final_Draft.id)
1 | Breaking News Story | This is a news story about breaking news. | 1 | 1 | 1
2 | Feature on Local Business | A feature article about a local business. | 2 | 2 | 2

## Authors

author_id | firstname | lastname
--- | --- | ---
1 | Alice | Brown
2 | Charlie | Green

## Reporters

reporter_id | firstname | lastname
--- | --- | ---
1 | David | Black
2 | Eva | White