## Category

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

## Author

authorId | firstName | lastName | email | 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

## Article

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

## Publication

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