Newspapers
id | name | editor_in_chief | headquarters |
1 | The Daily Chronicle | Jane Doe | New York |
2 | Metro News | John Smith | London |
Magazines
id | magazine_name | publisher_name | publication_frequency |
1 | Vanity Fair | Condé Nast | Monthly |
2 | Time Magazine | Time Inc. | Weekly |
Circulation_numbers
newspaper_id | magazine_id | circulation |
(→ Newspapers.id) | (→ Magazines.id) | |
1 | 1 | 20000 |
2 | 2 | 20000 |
1 | None | 30000 |
None | 2 | 40000 |
Articles
article_id | title | content | author | publication_date | newspaper_id | magazine_id |
| | | | | (→ Newspapers.id) | (→ Magazines.id) |
1 | Article 1 Title | Content of article 1 | Author A | 2022-01-01 | 1 | 1 |
2 | Article 2 Title | Content of article 2 | Author B | 2022-01-02 | 2 | 1 |
Authors
author_id | first_name | last_name | email |
1 | Author C | Last Name | c@example.com |
2 | Author D | Last Name | d@example.com |
Article_Authors
article_id | author_id |
(→ Articles.article_id) | (→ Authors.author_id) |
1 | 1 |
2 | 2 |