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 |