Authors

AuthorIDFirstNameLastNameEmail
1JohnSmithjohnsmith@example.com
2JaneDoejanedoe@example.com
3BobBrownbobbrown@example.com
4AliceWhitealicewhite@example.com
5MikeGreenmikgreen@example.com

Articles

ArticleIDTitleContentPublishDateManaging_EditorCopy_EditorFinal_Draft
1First ArticleThis is content of first article...2024-02-19 14:01:08Managing Editor OneCopy Editor OneFinal Draft One
2Second ArticleThis is content of second article...2024-02-19 14:01:08Managing Editor TwoCopy Editor TwoFinal Draft Two
3Third ArticleThis is content of third article...2024-02-19 14:01:08Managing Editor ThreeCopy Editor ThreeFinal Draft Three
4Fourth ArticleThis is content of fourth article...2024-02-19 14:01:08Managing Editor FourCopy Editor FourFinal Draft Four
5Fifth ArticleThis is content of fifth article...2024-02-19 14:01:08Managing Editor FiveCopy Editor FiveFinal Draft Five

Readers

ReaderIDNameSubscriptionDatePreferredEmail
1Subscriber One2021-01-01subone@example.com
2Subscriber Two2021-01-02subtwo@example.com
3Subscriber Three2021-01-03subthree@example.com
4Subscriber Four2021-01-04subfour@example.com
5Subscriber Five2021-01-05subfive@example.com

Comments

CommentIDArticleIDReaderIDCommentTextRating
(→ Articles.ArticleID)(→ Readers.ReaderID)
111Great article!5
212Interesting read.4
321Not bad but could be better.3
422Could use improvement.2
531Love this!5

Advertisements

AdIDDescriptionImgURLStartDateEndDatePrice
1Car ad descriptionhttp://caradimageurl.com/img.jpg2021-01-062021-01-1210000
2Electronics ad descriptionhttp://electronicadimageurl.com/img.jpg2021-01-132021-01-197500
3Clothing ad descriptionhttp://clothingadimageurl.com/img.jpg2021-01-202021-01-265000
4Job ad descriptionhttp://jobadimageurl.com/img.jpg2021-01-272021-01-31Free
5Real Estate ad descriptionhttp://realestateadimageurl.com/img.jpg2021-02-012021-02-058000

AdAssignments

AdAssignmentIDAdIDArticleIDAssignmentDate
(→ Advertisements.AdID)(→ Articles.ArticleID)
1112021-01-01
2222021-01-02
3332021-01-03
4442021-01-04
5552021-01-05