| id | name | phoneNumber | |
|---|---|---|---|
| 1 | John Doe | john@example.com | 1234567890 |
| 2 | Jane Roe | jane@example.com | 987654321 |
| id | name | type | contactInfo |
|---|---|---|---|
| 1 | New York Times | Daily Newspaper | nytimes@example.com |
| 2 | Wall Street Journal | Business Daily | wsj@example.com |
| 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. |
| 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 |