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 |