Newspapers

idNameFormatDistributorFoundedDate
(→ Distributors.Name)
1The TimesBroadsheetSainsbury's1785-01-01
2The SunTabloidSainsbury's1964-03-17
3Mail on SundayCompactTesco1982-01-01
4Guardian UnlimitedBerlinerTesco1999-01-01
5Financial TimesTabloidDirect delivery1888-01-01

Distributors

idNameAddressPhoneNumberEmailAddress
1Sainsbury's123 High St+44 1234567890distribution@sainburys.com
2Tesco456 Low St+44 0987654321distribution@tesco.com

Articles

idTitleContentPublicationDateNewspaperIdAuthorIdCategoryId
(→ Newspapers.id)(→ Authors.id)(→ ArticleCategories.id)
1UK Election ResultsHere are the results of the latest UK election.2021-10-01211
2Stock Market RisesThe stock market experienced significant gains today.2021-10-01322

Authors

idFirstNameLastNameBirthdate
1JohnSmith1960-01-01
2JaneDoe1975-05-01

ArticleCategories

idCategoryNameDescription
1PoliticsNews about governmental activities
2EconomyBusiness news and analysis