| 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 |