Authors

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

Articles

ArticleIDTitleContentTextPublishDateViewCountAuthorID
(→ Authors.AuthorID)
1Article 1Content of article 1...2024-03-13 15:11:1801
2Article 2Content of article 2...2024-03-13 15:11:1802

Magazines

MagazineIDNameCategory
1Good HousekeepingLifestyle
2Another MagazineTechnology

News_Industry

IndustryIDEconomyColumnMagazineID
(→ Magazines.MagazineID)
1Advertising Revenue1
2Advertising Revenue2
3Subscription Fees1
4Subscription Fees3

Sources

SourceIDNameTypeContactEmail
1Newspaper APrintnewspaperA@example.com
2Newspaper BOnlinenewspaperB@example.com

ArticleSources

ArticleSourceIDArticleIDSourceIDSourceQuote
(→ Articles.ArticleID)(→ Sources.SourceID)
111Quote from Newspaper A on Article 1
222Quote from Newspaper B on Article 2