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 |