## Journalist

id | name | email | phoneNumber
--- | --- | --- | ---
1 | John Doe | john@example.com | 1234567890
2 | Jane Roe | jane@example.com | 987654321

## Source

id | name | type | contactInfo
--- | --- | --- | ---
1 | New York Times | Daily Newspaper | nytimes@example.com
2 | Wall Street Journal | Business Daily | wsj@example.com

## Category

id | name | description
--- | --- | ---
1 | Politics | A section dealing with governmental activities at local, national, or international levels.
2 | Economy | A section covering economic events such as stock market activity, corporate earnings reports, etc.

## News

id | title | content | date | journalistId | sourceId | categoryId | news_article_structures | student
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  | (→ Journalist.id) | (→ Source.id) | (→ Category.id) |  |
1 | First News Article | This is the first article. | 2024-03-07 23:49:36 | 1 | 1 | 1 | Inverted Pyramid | Anne Smith
2 | Second News Article | This is the second article. | 2024-03-07 23:49:36 | 1 | 1 | 2 | Inverted Pyramid | Alice Brown
3 | Third News Article | This is the third article. | 2024-03-07 23:49:36 | 2 | 2 | 1 | Chronological Structure | Anne Smith
4 | Fourth News Article | This is the fourth article. | 2024-03-07 23:49:36 | 2 | 2 | 2 | Chronological Structure | Bob Johnson