| 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 |