| 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 |
| 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 |
| deadlineID | deadlineDate |
|---|---|
| 1 | 2021-04-25 |
| 2 | 2021-04-26 |
| articleDeadlineID | newsArticleID | deadlineID |
|---|---|---|
| (→ NewsArticles.articleID) | (→ Deadlines.deadlineID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 1 | 2 |
| 4 | 2 | 1 |