Users (to store user details)
Properties (to store details of properties for sale or rent)
Property Types (to store details of different types of properties)
Amenities (to store details of different amenities that properties may have)
Property Amenities (to store details of which amenities each property has)
Locations (to store details of different locations)
Property Images (to store details of images for each property)
Role Type
User Favorites (to store user's favorite properties)
Reviews (to store user reviews of properties)
Users: user_id, username, email, password, created_at,updated_at
Properties:
property_id,
title,
description,
price,
created_at, updated_at,
property_type_id (foreign key referencing Property Types),
location_id (foreign key referencing Locations),
landlord_user_id (foreign key referencing Users)
availability
availability_date
rent period
rental_terms
bedroom_count
bathroom_count
sqft
furninshed - boolean
Property Types: property_type_id, name
