print_media

idmedia_namepublication_dateauthor_idaudience_size
(→ authors.id)
1The New York Times2021-08-191300000
2Los Angeles Daily News2021-07-25260000
3The Guardian2021-08-213120000
4Le Monde2021-08-23490000
5El PaĆ­s2021-08-22570000

online_media

idwebsite_urlpublication_dateauthor_idaudience_size
(→ authors.id)
1www.nytimes.com2021-08-191300000
2www.ladoscene.com2021-07-25260000
3www.theguardian.com2021-08-213120000
4www.lemonde.fr2021-08-23490000
5www.elpais.com2021-08-22570000

authors

idnameemail
1Author Aa@example.com
2Author Bb@example.com
3Author Cc@example.com
4Author Dd@example.com
5Author Ee@example.com

articles

idtitlecontentcategory_idpublished_in_printpublished_online
(→ categories.id)
1Article 1 TitleContent of Article 1111
2Article 2 TitleContent of Article 2201
3Article 3 TitleContent of Article 3311
4Article 4 TitleContent of Article 4401
5Article 5 TitleContent of Article 5511

categories

idname
1Category 1
2Category 2
3Category 3
4Category 4
5Category 5