## Real_Estate_Reporters

id | name | email
--- | --- | ---
1 | John Doe | john@example.com
2 | Jane Smith | jane@example.com
3 | Michael Johnson | michael@example.com
4 | Emily Davis | emily@example.com
5 | David Brown | david@example.com

## Markets

id | market_name | description
--- | --- | ---
1 | Luxury Homes | High-end residential properties.
2 | Affordable Housing | Moderately priced homes for first-time buyers.
3 | Commercial Properties | Offices, retail spaces, industrial buildings.
4 | Rural Land | Agriculture land and rural estates.
5 | Investment Properties | Properties purchased for investment purposes.

## Real_Estate_Reporters_Markets

reporter_id | market_id
--- | ---
(→ Real_Estate_Reporters.id) | (→ Markets.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 2

## Articles

article_id | title | content | published_date
--- | --- | --- | ---
1 | New Luxury Home Development | Details about a new luxury home development... | 2021-09-01
2 | First Time Buyers Guide | Tips for first time home buyers... | 2021-08-15
3 | Office Space Trends | The latest trends in office space... | 2021-07-30
4 | Farmland vs Investment Property | Comparing farmland and investment property... | 2021-06-20
5 | Retail Space Revival | How retail spaces are making a comeback... | 2021-05-15