Articles

idtitlecontentdate
1Article1Content12024-03-07 23:09:43
2Article2Content22024-03-07 23:09:43

Reporters

idnameemail
1Reporter1email1@example.com
2Reporter2email2@example.com

Sources

idnameeventperson
1Source1Press ConferenceJack Layton
2Source2Press ConferenceJohn Doe
3Source3Media ScrumJack Layton
4Source4Media ScrumJane Smith

Categories

idname
1Category1
2Category2

ArticleCategories

article_idcategory_id
(→ Articles.id)(→ Categories.id)
11
22

ArticleSources

source_idarticle_id
(→ Sources.id)(→ Articles.id)
11
22
31
42

ArticleReporters

reporter_idarticle_id
(→ Reporters.id)(→ Articles.id)
11
22