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 |