Category

idcategoryNamedescription
1PoliticsNews related to political events
2EconomyNews about economic trends and financial markets
3TechnologyLatest news on technology advancements
4EntertainmentCelebrity gossip, movies, music, etc.
5HealthMedical research, health tips, and wellness
6TravelTips and articles on popular travel destinations

Author

authorIdfirstNamelastNameemailphoneNumber
(→ Publication.editorEmail)
1JohnDoejohndoe@example.com123-456-7890
2JaneSmithjanesmith@example.com987-654-3210
3MichaelJohnsonmichaeljohnson@example.com555-555-5550
4EmilyWilliamsemilywilliams@example.com555-123-4560
5DavidBrowndavidbrown@example.com555-789-0123

Article

articleIdtitlecontentpublicationDateAudience_MetricsyearviewscommentsCountsharesCountauthorIdcategoryIdpublicationId
(→ Author.authorId)(→ Category.id)(→ Publication.publicationId)
1Presidential ElectionsA detailed analysis of the upcoming presidential elections.2022-05-01 12:00:00Readership2022100050200111
2Stock Market UpdateAn overview of the stock market performance this week.2021-06-01 12:00:00Readership202180040150222
3New Tech InnovationsExploring the latest tech innovations and their potential impact.2022-04-01 12:00:00Website Traffic202270030120333
4Oscar Winners ReviewReviewing the best films and performances at this year's Oscars.2021-03-01 12:00:00Website Traffic202160020100444
5Yoga Retreat ExperienceA personal account of a yoga retreat experience in Bali.2021-10-01 12:00:00Readership20215001580555
6Viral Health TrendsDiscussing the latest viral health trends and fads.2022-06-01 12:00:00Website Traffic2022120060300666

Publication

publicationIdpublicationNameeditorFirstNameeditorLastNameeditorEmailcontactPhoneNumber
1The Daily NewsAliceWonderlandalicewonderland@example.com555-987-6540
2Financial TimesCharlieBankscharliebanks@example.com555-135-7900
3Tech TodayRobertGellerrobertgeller@example.com555-456-1230
4Hollywood InsiderKristenStewartkristenstewart@example.com555-678-9012
5Wellbeing WorldHelenClarkhelenclark@example.com555-012-3456
6Lonely PlanetMarkTwainmarktwain@example.com555-555-5556