Database Development

Developing a system where users are able to register, log in and submit their recipe’s a database is needed. Relevant rows need to be in a table and there can be more than one. In some cases tables may pull data from others depending on the data that is being stored.

Using software called ‘phpMyAdmin’ you are able to install the SQL database to a server. If you are interested in setting one up click this link and follow the instructions.

This only works for Mac’s but you can download an app called ‘Sequel Pro’ that allows you to interact with the GUI (graphic user interface) of the SQL databases. You are able to do everything phpMyAdmin does, but in a much richer UI (user interface) experience. If you are interested in that as well you can download it here.

 

database user
Design structure for user’s info in the table ‘users’

Each row has been designed with the correct data types:

  • INT – Used for the id for each user (Primary Key)
  • VARCHAR – Each row with this data type can carry any character (numbers, letters and symbols)

 

database user content
The ‘users’ table in content form

There are six columns of information:

  • id
  • username
  • password
  • first name
  • last name
  • email

This table will be able to be linked up to using PHP forms and coding communications. The only fields that will be required to sign-in are the username and password.

 

database posts
Design structure for post info in ‘posts’ table

The ‘post’ table is going to need to be refine-able in the search options of Yumi. Again, each row has been designed with the correct data types:

  • INT – Used for the id for each user (Primary Key)
  • VARCHAR – Each row with this data type can carry any character (numbers, letters and symbols)
  • Length – Certain fields have limited characters so the web app is more controlled when displaying relevant data

 

database posts content
The ‘posts’ table in content form

There are eight rows of information:

  • id
  • name
  • description
  • direction
  • ingredient
  • time
  • level
  • course
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