AuthorID | FirstName | LastName |
---|---|---|
1 | John | Doe |
2 | Jane | Smith |
3 | Alice | Brown |
4 | Mike | Green |
5 | Emma | White |
PubID | Title | Magazine |
---|---|---|
1 | News Article | The New Yorker |
2 | Feature Story | Time |
3 | Opinion Piece | Washington Post |
4 | Investigative Report | Vanity Fair |
5 | Profile Interview | Forbes |
ArticleID | ContentText | PublishDate | AuthorID | PubID |
---|---|---|---|---|
(→ Authors.AuthorID) | (→ Publications.PubID) | |||
1 | This is a news article content... | 2021-08-10 | 1 | 1 |
2 | Another news article content... | 2021-09-13 | 2 | 2 |
3 | Here is an opinion piece content... | 2021-10-07 | 3 | 4 |
4 | This investigative report content... | 2021-11-05 | 4 | 5 |
5 | A profile interview content... | 2021-12-02 | 5 | 6 |
CommunicationID | TypeOfCommunication | PubID |
---|---|---|
(→ Publications.PubID) | ||
1 | Social Media | 1 |
2 | Social Media Different Mag | 2 |
3 | Email Newsletters | 1 |
4 | Email Newsletters Diff Mag | 2 |
5 | Podcasts | 3 |
6 | Webinars | 4 |