id | Job_Title | NewsAgencyID |
---|---|---|
1 | Public Relations | 1 |
2 | Public Relations | 2 |
3 | Government Communications | 1 |
4 | Government Communications | 2 |
5 | Editorial Director | 3 |
id | Contacts |
---|---|
1 | Contact1@bbc.com |
2 | Contact2@abcnews.com |
3 | Contact3@nytimes.com |
ArticleId | Title | Content | PublishDate | AuthorID | AgencyID |
---|---|---|---|---|---|
(→ Journalists.id) | (→ NewsAgencies.id) | ||||
1 | Article1 | Content of article 1... | 2022-07-01 10:00:00 | 1 | 1 |
2 | Article2 | Content of article 2... | 2022-07-02 10:00:00 | 2 | 2 |
3 | Article3 | Content of article 3... | 2022-07-03 10:00:00 | 3 | 1 |
id | Name | Contact | RoleID | ArticleID |
---|---|---|---|---|
(→ JobRoles.id) | (→ Articles.ArticleId) | |||
1 | John Doe | john.doe@example.com | 1 | 1 |
2 | Jane Smith | jane.smith@example.com | 2 | 2 |
3 | Michael Johnson | michael.johnson@example.com | 3 | 3 |