AuthorID | FirstName | LastName | |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
PubID | Name | Digital_communication | Magazine | Printed_version |
---|---|---|---|---|
1 | The New Yorker | Social Media | The New Yorker | 1 |
2 | Another Magazine | Social Media | Some Other Magazine | 0 |
3 | Email Updates | Email Newsletters | The New Yorker | 1 |
4 | More Info | Email Newsletters | Another Company | 0 |
ArticleID | Title | Content | PublishDate | AuthorID | PubID | CategoryID |
---|---|---|---|---|---|---|
(→ Authors.AuthorID) | (→ Publications.PubID) | (→ Categories.CategoryID) | ||||
1 | Article 1 | Content of article 1 | 2023-01-01 10:00:00 | 1 | 1 | 1 |
2 | Article 2 | Content of article 2 | 2023-01-02 10:00:00 | 2 | 2 | 2 |
3 | Third Article | Content of third article | 2023-01-03 10:00:00 | 1 | 3 | 3 |
4 | Fourth Article | Content of fourth article | 2023-01-04 10:00:00 | 2 | 4 | 4 |
5 | Fifth Article | Content of fifth article | 2023-01-05 10:00:00 | 1 | 5 | 5 |
CategoryID | Name |
---|---|
1 | Politics |
2 | Technology |
3 | Culture |
4 | Business |
5 | Health |