## authors

authorID | name
--- | ---
1 | John Doe
2 | Jane Smith
3 | Alice Johnson
4 | Bob Brown
5 | Charlie Green

## articles

articleID | title | content | publishDate | author
--- | --- | --- | --- | ---
|  |  |  | (→ authors.authorID)
1 | The world's largest robots | This article discusses the latest advancements in robotics technology... | 2024-03-13 20:57:42 | None
2 | Climate change and its impact on agriculture | A comprehensive analysis of how climate change is affecting global agricultural practices... | 2024-03-13 20:57:42 | None
3 | Revolutionary breakthroughs in renewable energy | An exploration of recent innovations in solar, wind, and other green energy sources... | 2024-03-13 20:57:42 | None
4 | Advancements in space exploration | Examining the progress made in sending humans to Mars and beyond... | 2024-03-13 20:57:42 | None
5 | The rise of electric vehicles | A look at the growing popularity of electric cars and their implications for the automotive industry... | 2024-03-13 20:57:42 | None

## photos

photoID | path | description | articleID
--- | --- | --- | ---
(→ photos.photoID) |  |  | (→ articles.articleID)
1 | images/robot_1.jpg | Closeup image of a giant robot. | 1
2 | images/agriculture_field.jpg | Lush fields of crops being affected by drought. | 2
3 | images/wind_farm.jpg | Wind turbines generating clean energy against a sunset backdrop. | 3
4 | images/mars_lander.jpg | Mission control watching as a rover lands on Mars. | 4
5 | images/tesla_model_s.jpg | Electric car charging station along a highway. | 5

## videos

videoID | url | description | articleID
--- | --- | --- | ---
(→ videos.videoID) |  |  | (→ articles.articleID)
1 | https://www.youtube.com/watch?v=abcdefg123 | Interview with a leading robotics expert. | 1
2 | https://www.youtube.com/watch?v=hijklmnopqr | Documentary on the effects of climate change on farming communities. | 2
3 | https://www.youtube.com/watch?v=stuvwxyz123 | Innovative solar panel designs for residential use. | 3
4 | https://www.youtube.com/watch?v=9876543210 | SpaceX launching another successful mission to Mars. | 4
5 | https://www.youtube.com/watch?v=jkmnlpqrtu | Tesla Model S acceleration test on a racetrack. | 5

## article_details

detailID | details | articleID
--- | --- | ---
|  | (→ articles.articleID)
1 | Key takeaways from the interview. | 1
2 | Impacts on food security around the globe. | 2
3 | New developments in photovoltaic cell efficiency. | 3
4 | Colonization efforts for future human settlements. | 4
5 | Government incentives for EV adoption. | 5