AuthorID | FirstName | LastName | EmailAddress |
---|---|---|---|
1 | John | Doe | johndoe@example.com |
2 | Jane | Smith | janesmith@example.com |
ArticleID | Title | Content | PublishDate | ViewCount |
---|---|---|---|---|
1 | Article One | This is the content of article one. | 2024-02-19 14:58:28 | 100 |
2 | Article Two | Content of article two goes here. | 2024-02-19 14:58:28 | 80 |
PublisherID | Name | WebsiteURL | FoundedYear |
---|---|---|---|
1 | Publication A | https://www.publicationa.com | 2000 |
2 | Publication B | https://www.publicationb.com | 2001 |
OperationID | OperationYears | OperationMonths | MediaOutlet | Revenue | Expenses | ProfitMargin |
---|---|---|---|---|---|---|
1 | 10 | 12 | Newspaper X | 100000.0 | 75000.0 | 0.0 |
2 | 5 | 6 | Radio Y | 50000.0 | 30000.0 | 0.0 |
ReaderID | FullName | EmailAddress | RegistrationDate |
---|---|---|---|
1 | Alice Johnson | alicejohnson@example.com | 2024-02-19 14:58:28 |
2 | Bob Smith | bobsmit@example.net | 2024-02-19 14:58:28 |
SubscriptionID | ReaderID | PublisherID | StartDate | EndDate | Price |
---|---|---|---|---|---|
(→ Readers.ReaderID) | (→ Publications.PublisherID) | ||||
1 | 1 | 1 | 2024-02-19 14:58:28 | None | 9.99 |
2 | 2 | 2 | 2024-02-19 14:58:28 | None | 12.99 |