## Authors

authorID | name | email
--- | --- | ---
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

## Articles

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

## Sources

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/

## ArticleSources

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

## ContentManagementSystems

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

## EditorialTeamMembers

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