authorID | firstName | lastName | |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Michael | Brown | michael.brown@example.com |
4 | Emily | White | emily.white@example.com |
5 | David | Green | david.green@example.com |
articleID | title | content | publishDate | authorID |
---|---|---|---|---|
(→ Authors.authorID) | ||||
1 | The Importance of Investigative Journalism | A deep dive into how investigative journalism can uncover corruption and hold power accountable. | 2023-01-01 | 1 |
2 | The Future of Digital Media | How digital media is changing the landscape of modern journalism. | 2023-01-15 | 2 |
3 | Fact-Checking in a Post-Truth World | Exploring the role of fact-checkers in an era where misinformation spreads like wildfire. | 2023-01-22 | 3 |
4 | Journalistic Ethics: A Code of Conduct | Understanding the ethical standards that journalists must adhere to. | 2023-01-29 | 4 |
5 | Censorship and Freedom of the Press | A discussion on the challenges faced by journalists in countries with limited press freedom. | 2023-02-05 | 5 |
magazineID | name | publisher | ISSN |
---|---|---|---|
1 | World News Weekly | Global Publishing House | 978-3-16-148410-0 |
2 | Investigate This! | Journalism Watchdog Association | 978-3-16-148411-7 |
3 | Digital Frontiers | Tech Innovators Network | 978-3-16-148412-4 |
4 | Ethical Matters | Media Standards Council | 978-3-16-148413-1 |
5 | Press Freedoms International | Freedom Advocacy Group | 978-3-16-148414-8 |
magazineArticleID | articleID | magazineID | publicationMonth | publicationYear |
---|---|---|---|---|
(→ Articles.articleID) | (→ Magazines.magazineID) | |||
1 | 1 | 1 | 1 | 2023 |
2 | 2 | 1 | 2 | 2023 |
3 | 3 | 2 | 1 | 2023 |
4 | 4 | 2 | 2 | 2023 |
5 | 5 | 3 | 1 | 2023 |
demographicID | demographic_group | professional_field | magazineID |
---|---|---|---|
(→ Magazines.magazineID) | |||
1 | General Readership | Business Professional | 1 |
2 | Technology Enthusiasts | IT Specialist | 2 |
3 | Current Affairs | Political Analyst | 3 |
4 | Ethics Focused | Lawyer | 4 |
5 | International Relations | Diplomat | 5 |
subscriptionID | customerName | customerEmail | startDate | endDate | magazineID |
---|---|---|---|---|---|
(→ Magazines.magazineID) | |||||
1 | Alice Johnson | alice.johnson@example.com | 2023-01-01 | 2023-12-31 | 1 |
2 | Bob Smith | bob.smith@example.com | 2023-01-15 | 2023-12-31 | 2 |
3 | Carol Brown | carol.brown@example.com | 2023-01-22 | 2023-12-31 | 3 |
4 | Daniel Green | daniel.green@example.com | 2023-01-29 | 2023-12-31 | 4 |
5 | Emma White | emma.white@example.com | 2023-02-05 | 2023-12-31 | 5 |