## Author

id | name | email
--- | --- | ---
1 | Alice Smith | alice@example.com
2 | Bob Johnson | bob@example.com
3 | Charlie Brown | charlie@example.com
4 | David Lee | david@example.com
5 | Eva Green | eva@example.com

## Category

id | title | description
--- | --- | ---
1 | Politics | Latest political events.
2 | Culture | Cultural happenings around the world.
3 | Technology | The latest tech trends.
4 | Business | Global business news.
5 | Entertainment | Hollywood gossip and entertainment news.

## Publication

id | name | address
--- | --- | ---
1 | New York Times | 229 W 43rd St, New York, NY 10036, USA
2 | Washington Post | 1301 K Street NW, Washington, DC 20071, USA
3 | Wall Street Journal | One Market Plaza, San Francisco, CA 94105, USA
4 | Los Angeles Times | 202 W 1st St, Los Angeles, CA 90012, USA
5 | USA Today | 1 Tower Center Blvd, Secaucus, NJ 07094, USA

## Article

id | title | content | news_content_type | volume | date | author_id | category_id | publication_id
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Author.id) | (→ Category.id) | (→ Publication.id)
1 | Opinion on Brexit | This is a piece about... | Opinion Piece | 01 | 2024-03-07 23:50:16 | 1 | 1 | 1
2 | Climate Change Solutions | A discussion about... | Opinion Piece | 02 | 2024-03-07 23:50:16 | 2 | 3 | 2
3 | Apple Launches iPhone 12 | Details of Apple’s new phone. | Feature Article | 01 | 2024-03-07 23:50:16 | 3 | 4 | 3
4 | Tesla’s Solar Roof | Innovations by Tesla in solar energy. | Feature Article | 03 | 2024-03-07 23:50:16 | 4 | 5 | 4
5 | Stock Market Rises | Details of today’s stock market rise. | News | 01 | 2024-03-07 23:50:16 | 5 | 2 | 5
6 | Football Game Results | Results of last night’s football game. | Sports | 02 | 2024-03-07 23:50:16 | 1 | 6 | 1