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 |