## Reporters

reporterID | fullName | emailAddress | phoneNumber | role
--- | --- | --- | --- | ---
1 | John Doe | johndoe@example.com | 123-456-7890 | Reporter
2 | Jane Smith | janesmith@example.com | 098-765-4321 | Photographer

## NewsArticles

articleID | title | content | publishedDate | assignedTo
--- | --- | --- | --- | ---
|  |  |  | (→ Reporters.reporterID)
1 | Breaking News Story | This is a breaking news story... | 2021-04-01 | 1
2 | Featured Photo Essay | A captivating photo essay about... | 2021-04-02 | 2

## Deadlines

deadlineID | deadlineDate
--- | ---
1 | 2021-04-25
2 | 2021-04-26

## ArticleDeadlines

articleDeadlineID | newsArticleID | deadlineID
--- | --- | ---
| (→ NewsArticles.articleID) | (→ Deadlines.deadlineID)
1 | 1 | 1
2 | 2 | 2
3 | 1 | 2
4 | 2 | 1