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