Authors

idauthorName
1John Doe
2Jane Smith
3Michael Johnson
4Emily Davis
5David Brown

NewsArticles

idarticleTitlenewsDateauthorId
(→ Authors.id)
1First Article2023-01-011
2Second Article2023-01-022
3Third Article2023-01-033
4Fourth Article2023-01-044
5Fifth Article2023-01-055

ArticleSections

idsectionTitlecontentarticleId
(→ NewsArticles.id)
1IntroductionThis is an introduction...1
2BodyThis is the body of the article...1
3ConclusionThis is the conclusion...1
4IntroductionAnother introduction...2
5BodyMore text about the topic...2

MediaFiles

idfilePatharticleSectionId
(→ ArticleSections.id)
1image1.jpg1
2video1.mp42
3audio1.mp33
4image2.jpg4
5infographic1.png5

Comments

idcommentTextuserNamearticleId
(→ NewsArticles.id)
1Great read!User11
2Interesting perspective.User21
3I disagree with this point...User32
4Well explained!User42
5Could use some improvement.User53

News_Elements

idelementTypevaluearticleId
(→ NewsArticles.id)
1HeadlineGopnik's Headline1
2HeadlineDifferent Author's Headline2
3LedeGopnik's Lede1
4LedeDifferent Author's Lede3