Authors

AuthorIDName
1Adam Gopnik
2Jane Doe
3John Smith
4Emily Dickinson
5Mark Twain

News

NewsIDHeadlineLedePublishDateAuthorID
(→ Authors.AuthorID)
1GOPNIK HEADLINEThis is a headline by Adam Gopnik2021-10-171
2OTHER HEADLINEThis is another headline2021-10-182
3GOPNIK LEDEThis is a lede by Adam Gopnik2021-10-191
4OTHER LEDEThis is another lede2021-10-203
5ANOTHER NEWSThis news does not have an author2021-10-21None

NewsSources

SourceIDName
1The New Yorker
2The Times
3CNN
4BBC
5Washington Post

Articles

ArticleIDTitleContentNewsSourceID
(→ NewsSources.SourceID)
1ARTICLE TITLEThis is the content of article one1
2ARTICLE TWOThis is the second article2
3THIRD ARTICLEHere we go again with another article3
4FOURTH ARTICLEFourth time is the charm4
5FIFTH ARTICLELast but not least5

ArticleContents

ContentsIDArticleIDContentTypeFilePath
(→ Articles.ArticleID)
11TEXTtextfilepathone.txt
22IMAGEimagefilepathtwo.jpg
33AUDIOaudiofilepaththree.mp3
44VIDEOvideofilepathfour.mov
55MIXED MEDIAmixedmediapathfive.html