id | name | age | major |
---|---|---|---|
1 | John Doe | 20 | Journalism |
2 | Jane Smith | 23 | Mass Communication |
3 | Michael Johnson | 22 | Media Studies |
4 | Emma Brown | 21 | Broadcast Journalism |
5 | Anne Smith | 24 | Print Journalism |
id | title | content | structure | published_date | student_name |
---|---|---|---|---|---|
(→ Students.name) | |||||
1 | First Article Title | Content of first article... | Inverted Pyramid | 2022-01-01 | Anne Smith |
2 | Second Article Title | Content of second article... | Inverted Pyramid | 2022-01-02 | Michael Johnson |
3 | Third Article Title | Content of third article... | Chronological Structure | 2022-01-03 | Anne Smith |
4 | Fourth Article Title | Content of fourth article... | Chronological Structure | 2022-01-04 | Emma Brown |
5 | Fifth Article Title | Content of fifth article... | Inverted Pyramid | 2022-01-05 | John Doe |
category_id | category_name |
---|---|
1 | Politics |
2 | Economy |
3 | Technology |
4 | Entertainment |
5 | Sports |
article_id | category_id |
---|---|
(→ NewsArticles.id) | (→ ArticleCategories.category_id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
source_id | source_name | url |
---|---|---|
1 | The Guardian | https://www.theguardian.com/ |
2 | BBC News | https://www.bbc.co.uk/news |
3 | Al Jazeera | https://www.aljazeera.com/ |
4 | Reuters | https://www.reuters.com/ |
5 | The New York Times | https://www.nytimes.com/ |
article_id | source_id |
---|---|
(→ NewsArticles.id) | (→ Sources.source_id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |