## Articles

id | title | content | date
--- | --- | --- | ---
1 | Article1 | Content1 | 2024-03-07 23:09:43
2 | Article2 | Content2 | 2024-03-07 23:09:43

## Reporters

id | name | email
--- | --- | ---
1 | Reporter1 | email1@example.com
2 | Reporter2 | email2@example.com

## Sources

id | name | event | person
--- | --- | --- | ---
1 | Source1 | Press Conference | Jack Layton
2 | Source2 | Press Conference | John Doe
3 | Source3 | Media Scrum | Jack Layton
4 | Source4 | Media Scrum | Jane Smith

## Categories

id | name
--- | ---
1 | Category1
2 | Category2

## ArticleCategories

article_id | category_id
--- | ---
(→ Articles.id) | (→ Categories.id)
1 | 1
2 | 2

## ArticleSources

source_id | article_id
--- | ---
(→ Sources.id) | (→ Articles.id)
1 | 1
2 | 2
3 | 1
4 | 2

## ArticleReporters

reporter_id | article_id
--- | ---
(→ Reporters.id) | (→ Articles.id)
1 | 1
2 | 2