## 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