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 |