Database – Entity Relationship Diagrams .2

design for digital media environments
php1

Users table

php2

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.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s