authorID | name | |
---|---|---|
1 | John Doe | johndoe@example.com |
2 | Jane Smith | janesmith@example.com |
3 | Michael Johnson | michaeljohnson@example.com |
4 | Emily Brown | emilybrown@example.com |
5 | David Wilson | davidwilson@example.com |
articleID | title | content | publicationDate | authorID |
---|---|---|---|---|
(→ Authors.authorID) | ||||
1 | First Article Title | This is the first article content. | 2024-02-19 14:35:51 | 1 |
2 | Second Article Title | This is the second article content. | 2024-02-19 14:35:51 | 2 |
3 | Third Article Title | This is the third article content. | 2024-02-19 14:35:51 | 3 |
4 | Fourth Article Title | This is the fourth article content. | 2024-02-19 14:35:51 | 4 |
5 | Fifth Article Title | This is the fifth article content. | 2024-02-19 14:35:51 | 5 |
sourceID | name | url |
---|---|---|
1 | The New York Times | https://www.nytimes.com/ |
2 | CNN | https://www.cnn.com/ |
3 | BBC News | https://www.bbc.co.uk/news/ |
4 | Al Jazeera | https://www.aljazeera.com/ |
5 | Deutsche Welle | https://www.dw.com/ |
articleSourceID | articleID | sourceID | referenceDate |
---|---|---|---|
(→ Articles.articleID) | (→ Sources.sourceID) | ||
1 | 1 | 1 | 2021-07-01 10:00:00 |
2 | 2 | 2 | 2021-07-01 10:00:00 |
3 | 3 | 3 | 2021-07-01 10:00:00 |
4 | 4 | 4 | 2021-07-01 10:00:00 |
5 | 5 | 5 | 2021-07-01 10:00:00 |
cmsId | Technology | Online_News_Platform |
---|---|---|
(→ Articles.authorID) | ||
1 | WordPress | Newspack |
2 | Drupal | Tribune Content Agency |
3 | Joomla | LimeSurvey |
4 | Plone | Pelagios |
5 | Concrete5 | Zen Cart |