Authors

AuthorIDFirstNameLastNameEmail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com

Publications

PubIDNameDigital_communicationMagazinePrinted_version
1The New YorkerSocial MediaThe New Yorker1
2Another MagazineSocial MediaSome Other Magazine0
3Email UpdatesEmail NewslettersThe New Yorker1
4More InfoEmail NewslettersAnother Company0

Articles

ArticleIDTitleContentPublishDateAuthorIDPubIDCategoryID
(→ Authors.AuthorID)(→ Publications.PubID)(→ Categories.CategoryID)
1Article 1Content of article 12023-01-01 10:00:00111
2Article 2Content of article 22023-01-02 10:00:00222
3Third ArticleContent of third article2023-01-03 10:00:00133
4Fourth ArticleContent of fourth article2023-01-04 10:00:00244
5Fifth ArticleContent of fifth article2023-01-05 10:00:00155

Categories

CategoryIDName
1Politics
2Technology
3Culture
4Business
5Health