| 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 |