Reporters
id | name | birthDate | email |
1 | John Doe | 1987-06-13 | john@example.com |
2 | Jane Smith | 1990-03-18 | jane@example.com |
Articles
id | title | content | publishDate | reporterId | categoryId |
| | | | (→ Reporters.id) | (→ Categories.id) |
1 | Article Title 1 | Content of article 1 | 2021-07-01 | 1 | 1 |
2 | Article Title 2 | Content of article 2 | 2021-07-02 | 2 | 2 |
Categories
id | name |
1 | Politics |
2 | Economy |
3 | Technology |
Awards
id | awardName | year |
1 | Pulitzer Prize | 2010 |
2 | Pulitzer Prize | 2011 |
3 | George Polk Award | 2010 |
4 | George Polk Award | 2012 |
Reporter_Awards
reporterId | awardId |
(→ Reporters.id) | (→ Awards.id) |
1 | 1 |
2 | 2 |