## Authors

AuthorID | Name
--- | ---
1 | Adam Gopnik
2 | Jane Doe
3 | John Smith
4 | Emily Dickinson
5 | Mark Twain

## News

NewsID | Headline | Lede | PublishDate | AuthorID
--- | --- | --- | --- | ---
|  |  |  | (→ Authors.AuthorID)
1 | GOPNIK HEADLINE | This is a headline by Adam Gopnik | 2021-10-17 | 1
2 | OTHER HEADLINE | This is another headline | 2021-10-18 | 2
3 | GOPNIK LEDE | This is a lede by Adam Gopnik | 2021-10-19 | 1
4 | OTHER LEDE | This is another lede | 2021-10-20 | 3
5 | ANOTHER NEWS | This news does not have an author | 2021-10-21 | None

## NewsSources

SourceID | Name
--- | ---
1 | The New Yorker
2 | The Times
3 | CNN
4 | BBC
5 | Washington Post

## Articles

ArticleID | Title | Content | NewsSourceID
--- | --- | --- | ---
|  |  | (→ NewsSources.SourceID)
1 | ARTICLE TITLE | This is the content of article one | 1
2 | ARTICLE TWO | This is the second article | 2
3 | THIRD ARTICLE | Here we go again with another article | 3
4 | FOURTH ARTICLE | Fourth time is the charm | 4
5 | FIFTH ARTICLE | Last but not least | 5

## ArticleContents

ContentsID | ArticleID | ContentType | FilePath
--- | --- | --- | ---
| (→ Articles.ArticleID) |  |
1 | 1 | TEXT | textfilepathone.txt
2 | 2 | IMAGE | imagefilepathtwo.jpg
3 | 3 | AUDIO | audiofilepaththree.mp3
4 | 4 | VIDEO | videofilepathfour.mov
5 | 5 | MIXED MEDIA | mixedmediapathfive.html