id | Name | Social_Media | Email_Newsletters |
---|---|---|---|
1 | The New Yorker | https://www.facebook.com/newyorkermag | newsletter@thenewyorker.com |
2 | Wired | https://www.twitter.com/wired | newsletter@wired.com |
3 | National Geographic | https://www.instagram.com/natgeo | newsletter@nationalgeographic.com |
4 | Time | https://www.linkedin.com/company/time | newsletter@time.com |
5 | New Scientist | https://www.youtube.com/c/newscientistvideos | newsletter@newscientist.com |
id | FirstName | LastName | Bio |
---|---|---|---|
1 | John | Doe | A writer based in London. |
2 | Jane | Smith | An author who loves travelling and writing about her experiences. |
3 | Michael | Brown | A renowned journalist known for his investigative work. |
4 | Emily | White | An expert on environmental issues. |
5 | William | Black | A political analyst and commentator. |
id | Title | Content | PublishDate | MagazineID |
---|---|---|---|---|
(→ Magazine.id) | ||||
1 | The Future of AI | AI is changing our world... | 2024-03-13 20:53:33 | 1 |
2 | Climate Change Effects | Effects of climate change... | 2024-03-13 20:53:33 | 2 |
3 | Exploring Mars | Details about recent discoveries... | 2024-03-13 20:53:33 | 3 |
4 | Health Benefits of Exercise | Benefits of daily exercise... | 2024-03-13 20:53:33 | 4 |
5 | Tech Trends of 2022 | Predictions for the year ahead... | 2024-03-13 20:53:33 | 5 |
id | FullName | Age | City | Preferred_Magazines |
---|---|---|---|---|
1 | John Doe | 28 | Los Angeles | The New Yorker, Wired |
2 | Jane Smith | 35 | Chicago | National Geographic, Time |
3 | Michael Brown | 42 | San Francisco | New Scientist, National Geographic |
4 | Emily White | 31 | Denver | The New Yorker, The Economist |
5 | William Black | 47 | Seattle | Time, Forbes |
id | ReaderID | MagazineID | StartDate | EndDate |
---|---|---|---|---|
(→ Readership.id) | (→ Magazine.id) | |||
1 | 1 | 1 | 2022-01-01 | None |
2 | 2 | 2 | 2022-02-01 | 2022-12-31 |
3 | 3 | 3 | 2022-03-01 | 2023-02-28 |
4 | 4 | 4 | 2022-04-01 | 2023-03-31 |
5 | 5 | 5 | 2022-05-01 | None |
id | Content | ArticleID | AuthorID |
---|---|---|---|
(→ Article.id) | (→ Author.id) | ||
1 | Great article! | 1 | 1 |
2 | Very informative piece. | 2 | 2 |
3 | Interesting insights. | 3 | 3 |
4 | Well-written and engaging. | 4 | 4 |
5 | I enjoyed this perspective. | 5 | 5 |