print_media
id | media_name | publication_date | author_id | audience_size |
| | | (→ authors.id) | |
1 | The New York Times | 2021-08-19 | 1 | 300000 |
2 | Los Angeles Daily News | 2021-07-25 | 2 | 60000 |
3 | The Guardian | 2021-08-21 | 3 | 120000 |
4 | Le Monde | 2021-08-23 | 4 | 90000 |
5 | El PaĆs | 2021-08-22 | 5 | 70000 |
online_media
id | website_url | publication_date | author_id | audience_size |
| | | (→ authors.id) | |
1 | www.nytimes.com | 2021-08-19 | 1 | 300000 |
2 | www.ladoscene.com | 2021-07-25 | 2 | 60000 |
3 | www.theguardian.com | 2021-08-21 | 3 | 120000 |
4 | www.lemonde.fr | 2021-08-23 | 4 | 90000 |
5 | www.elpais.com | 2021-08-22 | 5 | 70000 |
authors
id | name | email |
1 | Author A | a@example.com |
2 | Author B | b@example.com |
3 | Author C | c@example.com |
4 | Author D | d@example.com |
5 | Author E | e@example.com |
articles
id | title | content | category_id | published_in_print | published_online |
| | | (→ categories.id) | | |
1 | Article 1 Title | Content of Article 1 | 1 | 1 | 1 |
2 | Article 2 Title | Content of Article 2 | 2 | 0 | 1 |
3 | Article 3 Title | Content of Article 3 | 3 | 1 | 1 |
4 | Article 4 Title | Content of Article 4 | 4 | 0 | 1 |
5 | Article 5 Title | Content of Article 5 | 5 | 1 | 1 |
categories
id | name |
1 | Category 1 |
2 | Category 2 |
3 | Category 3 |
4 | Category 4 |
5 | Category 5 |