| id | Name | Type | Founded |
|---|---|---|---|
| 1 | New York Times | Newspaper | 1857-09-18 |
| 2 | Breitbart News | Website | 2007-03-06 |
| id | FranchiseID | Platform | ExpandedOnDate |
|---|---|---|---|
| (→ Media_Franchises.id) | |||
| 1 | 1 | Web App | 2015-03-01 |
| 2 | 2 | Mobile Application | 2019-01-01 |
| id | Title | ContentText | PublishDate | AuthorId |
|---|---|---|---|---|
| (→ Authors.id) | ||||
| 1 | The Impact of Climate Change on Agriculture | A detailed analysis... | 2023-02-15 | 1 |
| 2 | Economic Outlook for 2023 | An overview of the global economy... | 2023-01-20 | 2 |
| id | PreferredNewsType | FavoriteFranchiseID |
|---|---|---|
| (→ Media_Franchises.id) | ||
| 1 | Politics | 1 |
| 2 | Technology | 2 |
| id | FirstName | LastName | Birthdate | Specialty |
|---|---|---|---|---|
| 1 | John | Doe | 1980-01-01 | Environmental Science |
| 2 | Jane | Smith | 1985-05-05 | Economy |
| id | ArticleId | AssignedToAuthorId | DueDate | Status |
|---|---|---|---|---|
| (→ Articles.id) | (→ Authors.id) | |||
| 1 | 1 | 1 | 2023-02-20 | In Progress |
| 2 | 2 | 2 | 2023-03-05 | Completed |