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 |