Authors
| id | name |
| 1 | John Doe |
| 2 | Jane Smith |
Articles
| id | title | written_by | Written_journalism | word_count |
| | (→ Authors.id) | | (→ WordCounts.column) |
| 1 | First News Article | 1 | News Article | 1,000 words |
| 2 | Second News Article | 2 | News Article | 800 words |
| 3 | First Feature Article | 3 | Feature Article | 1,000 words |
| 4 | Second Feature Article | 4 | Feature Article | 900 words |
WordCounts
| id | column |
| 1 | 1,000 words |
| 2 | 750 words |
| 3 | 1,200 words |
| 4 | 800 words |
| 5 | 1,100 words |
Publishers
| id | name |
| 1 | Newspaper XYZ |
| 2 | Magazine ABC |
Publications
| id | article_id | publisher_id | publication_date |
| (→ Articles.id) | (→ Publishers.id) | |
| 1 | 1 | 1 | 2023-01-01 |
| 2 | 2 | 2 | 2023-01-02 |
| 3 | 3 | 1 | 2023-01-03 |
| 4 | 4 | 2 | 2023-01-04 |
Comments
| id | comment | article_id |
| | (→ Articles.id) |
| 1 | Great article! | 1 |
| 2 | Interesting insights. | 2 |
| 3 | Well-written piece. | 3 |
| 4 | Enjoyed reading this. | 4 |