Authors

AuthorIDFirstNameLastNameEmailAddress
1JohnDoejohndoe@example.com
2JaneSmithjanesmith@example.com

Articles

ArticleIDTitleContentPublishDateViewCount
1Article OneThis is the content of article one.2024-02-19 14:58:28100
2Article TwoContent of article two goes here.2024-02-19 14:58:2880

Publications

PublisherIDNameWebsiteURLFoundedYear
1Publication Ahttps://www.publicationa.com2000
2Publication Bhttps://www.publicationb.com2001

Operations

OperationIDOperationYearsOperationMonthsMediaOutletRevenueExpensesProfitMargin
11012Newspaper X100000.075000.00.0
256Radio Y50000.030000.00.0

Readers

ReaderIDFullNameEmailAddressRegistrationDate
1Alice Johnsonalicejohnson@example.com2024-02-19 14:58:28
2Bob Smithbobsmit@example.net2024-02-19 14:58:28

Subscriptions

SubscriptionIDReaderIDPublisherIDStartDateEndDatePrice
(→ Readers.ReaderID)(→ Publications.PublisherID)
1112024-02-19 14:58:28None9.99
2222024-02-19 14:58:28None12.99