## Authors

AuthorID | FirstName | LastName | Email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com

## Articles

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

## Magazines

MagazineID | Name | Category
--- | --- | ---
1 | Good Housekeeping | Lifestyle
2 | Another Magazine | Technology

## News_Industry

IndustryID | EconomyColumn | MagazineID
--- | --- | ---
|  | (→ Magazines.MagazineID)
1 | Advertising Revenue | 1
2 | Advertising Revenue | 2
3 | Subscription Fees | 1
4 | Subscription Fees | 3

## Sources

SourceID | Name | Type | ContactEmail
--- | --- | --- | ---
1 | Newspaper A | Print | newspaperA@example.com
2 | Newspaper B | Online | newspaperB@example.com

## ArticleSources

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