Database – Entity Relationship Diagrams .2

design for digital media environments

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.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s