id | name | |
---|---|---|
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 |
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. |
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 |
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 |