Users table
Posts database table
Two tables: Users and posts
Data regarding the user is entered into the users table once signing up. Data such as username, name, password and email is stored. The posts table consists of information about the properties for example, house type, price, location, etc..the data will be called using php and jquery to display results on the web application.
Username and password are essential for logging in, the data will need to match to enable verification. This is important for security reasons. Each user is automatically assigned an identity number. This is similar with the properties listed, the id carries a time it was posted. The user id shows which user posted and at what time.
Charlotte Eagle 