id | name | url |
---|---|---|
1 | CNN | https://www.cnn.com |
2 | BBC | https://www.bbc.co.uk |
3 | The Guardian | https://www.theguardian.com |
4 | Al Jazeera | https://www.aljazeera.com |
5 | New York Times | https://www.nytimes.com |
id | name |
---|---|
1 | CNN App |
2 | BBC App |
3 | Guardian App |
4 | Al Jazeera App |
5 | NYT App |
id | name | websiteId | mobileAppId |
---|---|---|---|
(→ Website.id) | (→ Mobile_App.id) | ||
1 | CNN | 1 | 1 |
2 | BBC | 2 | 2 |
3 | The Guardian | 3 | 3 |
4 | Al Jazeera | 4 | 4 |
5 | New York Times | 5 | 5 |
id | title | content | publishedDate | newsAgencyId |
---|---|---|---|---|
(→ News_Agency.id) | ||||
1 | Test Article 1 | This is a test article. | 2024-02-19 14:31:13 | 1 |
2 | Test Article 2 | Another test article. | 2024-02-19 14:31:13 | 2 |
3 | Test Article 3 | Yet another test article. | 2024-02-19 14:31:13 | 3 |
4 | Test Article 4 | And here is one more test article. | 2024-02-19 14:31:13 | 4 |
5 | Test Article 5 | Last but not least, a test article! | 2024-02-19 14:31:13 | 5 |
id | firstName | lastName |
---|---|---|
1 | John | Doe |
2 | Jane | Smith |
3 | Michael | Johnson |
4 | Emily | Williams |
5 | David | Brown |
authorId | articleId |
---|---|
(→ Author.id) | (→ Article.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |