AuthorID | FirstName | LastName | |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
ArticleID | Title | ContentText | PublishDate | ViewCount | AuthorID |
---|---|---|---|---|---|
(→ Authors.AuthorID) | |||||
1 | Article 1 | Content of article 1... | 2024-03-13 15:11:18 | 0 | 1 |
2 | Article 2 | Content of article 2... | 2024-03-13 15:11:18 | 0 | 2 |
MagazineID | Name | Category |
---|---|---|
1 | Good Housekeeping | Lifestyle |
2 | Another Magazine | Technology |
IndustryID | EconomyColumn | MagazineID |
---|---|---|
(→ Magazines.MagazineID) | ||
1 | Advertising Revenue | 1 |
2 | Advertising Revenue | 2 |
3 | Subscription Fees | 1 |
4 | Subscription Fees | 3 |
SourceID | Name | Type | ContactEmail |
---|---|---|---|
1 | Newspaper A | newspaperA@example.com | |
2 | Newspaper B | Online | newspaperB@example.com |
ArticleSourceID | ArticleID | SourceID | SourceQuote |
---|---|---|---|
(→ Articles.ArticleID) | (→ Sources.SourceID) | ||
1 | 1 | 1 | Quote from Newspaper A on Article 1 |
2 | 2 | 2 | Quote from Newspaper B on Article 2 |