| id | name | url |
|---|---|---|
| 1 | The New Yorker | https://www.newyorker.com/ |
| 2 | Time Magazine | http://time.com/ |
| id | magazine_id | platform | followers |
|---|---|---|---|
| (→ Magazines.id) | |||
| 1 | 1 | 2000000 | |
| 2 | 2 | 3000000 |
| id | magazine_id | subscribers | frequency |
|---|---|---|---|
| (→ Magazines.id) | |||
| 1 | 1 | 100000 | Weekly |
| 2 | 2 | 80000 | Biweekly |
| id | name | |
|---|---|---|
| 1 | John Doe | johndoe@example.com |
| 2 | Jane Smith | janesmith@example.com |
| 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 |