| 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 | Content_Management_System | Web_Framework | Online_News_Platform |
|---|---|---|---|
| (→ Articles.authorID) | |||
| 1 | WordPress | PHP | Newspack |
| 2 | Drupal | PHP | Tribune Content Agency |
| 3 | Joomla | PHP | LimeSurvey |
| 4 | Plone | Python | Pelagios |
| 5 | Concrete5 | PHP | Zen Cart |
| memberID | role | editorName |
|---|---|---|
| 1 | Managing Editor | Mary Williams |
| 2 | Copy Chief | Tom Anderson |
| 3 | Features Editor | Ann Taylor |
| 4 | Sports Editor | Chris Harris |
| 5 | Opinion Editor | Laura King |