Journalists

idnameemailphoneNumberlanguages
1John Doejohn@example.com+1234567890English and Spanish
2Jane Smithjane@example.com+9876543210German and French

Editors

idnameemailphoneNumberlanguages
1Michael Johnsonmichael@example.com+0987654321English and Spanish
2Emily Davisemily@example.com+1234567890Italian and Portuguese

Publications

idtitlepublicationDate
1The Daily News2021-01-01
2Weekly Times2021-01-15

Articles

idtitlecontentpublishDateeditorId
(→ Editors.id)
1Article 1Content of Article 12021-01-011
2Article 2Content of Article 22021-01-152

ArticleAuthors

articleIdjournalistId
(→ Articles.id)(→ Journalists.id)
11
22

Subscriptions

idsubscriberEmailsubscriptionType
1subscription1@example.comPremium
2subscription2@example.comStandard