Add foreign keys to database schema

[AntiPaste]

Foreign keys should be added wherever needed.

Research:
http://www.sitepoint.com/mysql-foreign-keys-quicker-database-development/
http://stackoverflow.com/questions/757181/basics-of-foreign-keys-in-mysql