id | categoryName | description |
---|---|---|
1 | Politics | News related to political events |
2 | Economy | News about economic trends and financial markets |
3 | Technology | Latest news on technology advancements |
4 | Entertainment | Celebrity gossip, movies, music, etc. |
5 | Health | Medical research, health tips, and wellness |
6 | Travel | Tips and articles on popular travel destinations |
authorId | firstName | lastName | phoneNumber | |
---|---|---|---|---|
(→ Publication.editorEmail) | ||||
1 | John | Doe | johndoe@example.com | 123-456-7890 |
2 | Jane | Smith | janesmith@example.com | 987-654-3210 |
3 | Michael | Johnson | michaeljohnson@example.com | 555-555-5550 |
4 | Emily | Williams | emilywilliams@example.com | 555-123-4560 |
5 | David | Brown | davidbrown@example.com | 555-789-0123 |
articleId | title | content | publicationDate | Audience_Metrics | year | views | commentsCount | sharesCount | authorId | categoryId | publicationId |
---|---|---|---|---|---|---|---|---|---|---|---|
(→ Author.authorId) | (→ Category.id) | (→ Publication.publicationId) | |||||||||
1 | Presidential Elections | A detailed analysis of the upcoming presidential elections. | 2022-05-01 12:00:00 | Readership | 2022 | 1000 | 50 | 200 | 1 | 1 | 1 |
2 | Stock Market Update | An overview of the stock market performance this week. | 2021-06-01 12:00:00 | Readership | 2021 | 800 | 40 | 150 | 2 | 2 | 2 |
3 | New Tech Innovations | Exploring the latest tech innovations and their potential impact. | 2022-04-01 12:00:00 | Website Traffic | 2022 | 700 | 30 | 120 | 3 | 3 | 3 |
4 | Oscar Winners Review | Reviewing the best films and performances at this year's Oscars. | 2021-03-01 12:00:00 | Website Traffic | 2021 | 600 | 20 | 100 | 4 | 4 | 4 |
5 | Yoga Retreat Experience | A personal account of a yoga retreat experience in Bali. | 2021-10-01 12:00:00 | Readership | 2021 | 500 | 15 | 80 | 5 | 5 | 5 |
6 | Viral Health Trends | Discussing the latest viral health trends and fads. | 2022-06-01 12:00:00 | Website Traffic | 2022 | 1200 | 60 | 300 | 6 | 6 | 6 |
publicationId | publicationName | editorFirstName | editorLastName | editorEmail | contactPhoneNumber |
---|---|---|---|---|---|
1 | The Daily News | Alice | Wonderland | alicewonderland@example.com | 555-987-6540 |
2 | Financial Times | Charlie | Banks | charliebanks@example.com | 555-135-7900 |
3 | Tech Today | Robert | Geller | robertgeller@example.com | 555-456-1230 |
4 | Hollywood Insider | Kristen | Stewart | kristenstewart@example.com | 555-678-9012 |
5 | Wellbeing World | Helen | Clark | helenclark@example.com | 555-012-3456 |
6 | Lonely Planet | Mark | Twain | marktwain@example.com | 555-555-5556 |