## Media_Franchises

id | Name | Type | Founded
--- | --- | --- | ---
1 | New York Times | Newspaper | 1857-09-18
2 | Breitbart News | Website | 2007-03-06

## CrossPlatformExpansions

id | FranchiseID | Platform | ExpandedOnDate
--- | --- | --- | ---
| (→ Media_Franchises.id) |  |
1 | 1 | Web App | 2015-03-01
2 | 2 | Mobile Application | 2019-01-01

## Articles

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

## Audience

id | PreferredNewsType | FavoriteFranchiseID
--- | --- | ---
|  | (→ Media_Franchises.id)
1 | Politics | 1
2 | Technology | 2

## Authors

id | FirstName | LastName | Birthdate | Specialty
--- | --- | --- | --- | ---
1 | John | Doe | 1980-01-01 | Environmental Science
2 | Jane | Smith | 1985-05-05 | Economy

## ArticleAssignments

id | ArticleId | AssignedToAuthorId | DueDate | Status
--- | --- | --- | --- | ---
| (→ Articles.id) | (→ Authors.id) |  |
1 | 1 | 1 | 2023-02-20 | In Progress
2 | 2 | 2 | 2023-03-05 | Completed