## Authors

AuthorID | FirstName | LastName | Email
--- | --- | --- | ---
1 | John | Smith | johnsmith@example.com
2 | Jane | Doe | janedoe@example.com
3 | Bob | Brown | bobbrown@example.com
4 | Alice | White | alicewhite@example.com
5 | Mike | Green | mikgreen@example.com

## Articles

ArticleID | Title | Content | PublishDate | Managing_Editor | Copy_Editor | Final_Draft
--- | --- | --- | --- | --- | --- | ---
1 | First Article | This is content of first article... | 2024-02-19 14:01:08 | Managing Editor One | Copy Editor One | Final Draft One
2 | Second Article | This is content of second article... | 2024-02-19 14:01:08 | Managing Editor Two | Copy Editor Two | Final Draft Two
3 | Third Article | This is content of third article... | 2024-02-19 14:01:08 | Managing Editor Three | Copy Editor Three | Final Draft Three
4 | Fourth Article | This is content of fourth article... | 2024-02-19 14:01:08 | Managing Editor Four | Copy Editor Four | Final Draft Four
5 | Fifth Article | This is content of fifth article... | 2024-02-19 14:01:08 | Managing Editor Five | Copy Editor Five | Final Draft Five

## Readers

ReaderID | Name | SubscriptionDate | PreferredEmail
--- | --- | --- | ---
1 | Subscriber One | 2021-01-01 | subone@example.com
2 | Subscriber Two | 2021-01-02 | subtwo@example.com
3 | Subscriber Three | 2021-01-03 | subthree@example.com
4 | Subscriber Four | 2021-01-04 | subfour@example.com
5 | Subscriber Five | 2021-01-05 | subfive@example.com

## Comments

CommentID | ArticleID | ReaderID | CommentText | Rating
--- | --- | --- | --- | ---
| (→ Articles.ArticleID) | (→ Readers.ReaderID) |  |
1 | 1 | 1 | Great article! | 5
2 | 1 | 2 | Interesting read. | 4
3 | 2 | 1 | Not bad but could be better. | 3
4 | 2 | 2 | Could use improvement. | 2
5 | 3 | 1 | Love this! | 5

## Advertisements

AdID | Description | ImgURL | StartDate | EndDate | Price
--- | --- | --- | --- | --- | ---
1 | Car ad description | http://caradimageurl.com/img.jpg | 2021-01-06 | 2021-01-12 | 10000
2 | Electronics ad description | http://electronicadimageurl.com/img.jpg | 2021-01-13 | 2021-01-19 | 7500
3 | Clothing ad description | http://clothingadimageurl.com/img.jpg | 2021-01-20 | 2021-01-26 | 5000
4 | Job ad description | http://jobadimageurl.com/img.jpg | 2021-01-27 | 2021-01-31 | Free
5 | Real Estate ad description | http://realestateadimageurl.com/img.jpg | 2021-02-01 | 2021-02-05 | 8000

## AdAssignments

AdAssignmentID | AdID | ArticleID | AssignmentDate
--- | --- | --- | ---
| (→ Advertisements.AdID) | (→ Articles.ArticleID) |
1 | 1 | 1 | 2021-01-01
2 | 2 | 2 | 2021-01-02
3 | 3 | 3 | 2021-01-03
4 | 4 | 4 | 2021-01-04
5 | 5 | 5 | 2021-01-05