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 |