AuthorID | FirstName | LastName | EmailAddress |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Michael | Brown | michael.brown@example.com |
4 | Emily | White | emily.white@example.com |
5 | David | Black | david.black@example.com |
PublisherID | Name | Address |
---|---|---|
1 | Time Inc. | New York, USA |
2 | Conde Nast | London, UK |
3 | Hearst Corporation | New York, USA |
4 | Rodale Inc. | Emmaus, Pennsylvania, USA |
5 | Gannett Company | McLean, Virginia, USA |
MagazineID | Title | YearEstablished | PublisherId |
---|---|---|---|
(→ Publishers.PublisherID) | |||
1 | Time | 1923 | 1 |
2 | National Geographic | 1888 | 2 |
3 | People | 1974 | 3 |
4 | Men's Health | 1987 | 4 |
5 | USA Today | 1982 | 5 |
ArticleID | Title | PublicationDate | WordCount | MagazineId | AuthorId |
---|---|---|---|---|---|
(→ Magazines.MagazineID) | (→ Authors.AuthorID) | ||||
1 | Article One | 2024-02-19 15:09:29 | 1000 | 1 | 1 |
2 | Article Two | 2024-02-19 15:09:29 | 1500 | 2 | 2 |
3 | Article Three | 2024-02-19 15:09:29 | 2000 | 3 | 3 |
4 | Article Four | 2024-02-19 15:09:29 | 2500 | 4 | 4 |
5 | Article Five | 2024-02-19 15:09:29 | 3000 | 5 | 5 |
DocumentaryId | Title | ReleaseYear | Creator | LengthInMinutes | MagazineId |
---|---|---|---|---|---|
(→ Magazines.MagazineID) | |||||
1 | Doc One | 2001 | Producer One | 60 | 1 |
2 | Doc Two | 2002 | Producer Two | 90 | 2 |
3 | Doc Three | 2003 | Producer Three | 120 | 3 |
4 | Doc Four | 2004 | Producer Four | 150 | 4 |
5 | Doc Five | 2005 | Producer Five | 180 | 5 |