AuthorID | Name |
---|---|
1 | Adam Gopnik |
2 | Jane Doe |
3 | John Smith |
4 | Emily Dickinson |
5 | Mark Twain |
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 |
SourceID | Name |
---|---|
1 | The New Yorker |
2 | The Times |
3 | CNN |
4 | BBC |
5 | Washington Post |
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 |
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 |