| 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 |