Authors

AuthorIDFirstNameLastNameEmailAddress
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3MichaelBrownmichael.brown@example.com
4EmilyWhiteemily.white@example.com
5DavidBlackdavid.black@example.com

Publishers

PublisherIDNameAddress
1Time Inc.New York, USA
2Conde NastLondon, UK
3Hearst CorporationNew York, USA
4Rodale Inc.Emmaus, Pennsylvania, USA
5Gannett CompanyMcLean, Virginia, USA

Magazines

MagazineIDTitleYearEstablishedPublisherId
(→ Publishers.PublisherID)
1Time19231
2National Geographic18882
3People19743
4Men's Health19874
5USA Today19825

Articles

ArticleIDTitlePublicationDateWordCountMagazineIdAuthorId
(→ Magazines.MagazineID)(→ Authors.AuthorID)
1Article One2024-02-19 15:09:29100011
2Article Two2024-02-19 15:09:29150022
3Article Three2024-02-19 15:09:29200033
4Article Four2024-02-19 15:09:29250044
5Article Five2024-02-19 15:09:29300055

Documentaries

DocumentaryIdTitleReleaseYearCreatorLengthInMinutesMagazineId
(→ Magazines.MagazineID)
1Doc One2001Producer One601
2Doc Two2002Producer Two902
3Doc Three2003Producer Three1203
4Doc Four2004Producer Four1504
5Doc Five2005Producer Five1805