| id | name | |
|---|---|---|
| 1 | John Doe | john@example.com |
| 2 | Jane Smith | jane@example.com |
| 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 |
| author_id | firstname | lastname |
|---|---|---|
| 1 | Alice | Brown |
| 2 | Charlie | Green |
| reporter_id | firstname | lastname |
|---|---|---|
| 1 | David | Black |
| 2 | Eva | White |
| id | managing_editor_id |
|---|---|
| (→ Editor.id) | |
| 1 | 1 |
| 2 | 2 |