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 |