Media_Franchises

idNameTypeFounded
1New York TimesNewspaper1857-09-18
2Breitbart NewsWebsite2007-03-06

CrossPlatformExpansions

idFranchiseIDPlatformExpandedOnDate
(→ Media_Franchises.id)
11Web App2015-03-01
22Mobile Application2019-01-01

Articles

idTitleContentTextPublishDateAuthorId
(→ Authors.id)
1The Impact of Climate Change on AgricultureA detailed analysis...2023-02-151
2Economic Outlook for 2023An overview of the global economy...2023-01-202

Audience

idPreferredNewsTypeFavoriteFranchiseID
(→ Media_Franchises.id)
1Politics1
2Technology2

Authors

idFirstNameLastNameBirthdateSpecialty
1JohnDoe1980-01-01Environmental Science
2JaneSmith1985-05-05Economy

ArticleAssignments

idArticleIdAssignedToAuthorIdDueDateStatus
(→ Articles.id)(→ Authors.id)
1112023-02-20In Progress
2222023-03-05Completed