## Magazines

id | name | url
--- | --- | ---
1 | The New Yorker | https://www.newyorker.com/
2 | Time Magazine | http://time.com/

## Social_Media

id | magazine_id | platform | followers
--- | --- | --- | ---
| (→ Magazines.id) |  |
1 | 1 | Twitter | 2000000
2 | 2 | Instagram | 3000000

## Email_Newsletters

id | magazine_id | subscribers | frequency
--- | --- | --- | ---
| (→ Magazines.id) |  |
1 | 1 | 100000 | Weekly
2 | 2 | 80000 | Biweekly

## Authors

id | name | email
--- | --- | ---
1 | John Doe | johndoe@example.com
2 | Jane Smith | janesmith@example.com

## Articles

id | title | content | author_id | magazine_id | publication_date
--- | --- | --- | --- | --- | ---
|  |  | (→ Authors.id) | (→ Magazines.id) |
1 | Article Title 1 | Content of Article 1... | 1 | 1 | 2021-07-01
2 | Article Title 2 | Content of Article 2... | 2 | 1 | 2021-07-02
3 | Article Title 3 | Content of Article 3... | 1 | 2 | 2021-07-03
4 | Article Title 4 | Content of Article 4... | 2 | 2 | 2021-07-04
5 | Article Title 5 | Content of Article 5... | 1 | 1 | 2021-07-05