| id | name | |
|---|---|---|
| 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 |
| 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. |
| reporter_id | market_id |
|---|---|
| (→ Real_Estate_Reporters.id) | (→ Markets.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 2 |
| 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 |