Caledonia-2-u


   For my final project, I would like to create an online art/painting forum. My database tables would consist of user, topic, post, and comment tables. I would also like to have a more 'practical' database setup. My users table will include hashed passwords plus salt/pepper strings. A user will select a topic, from there they will be able to see what posts have been made about that topic and how many comments those posts have received. I will be modelling the site's front-end after some image-heavy sites such as criterion.com. I will be developing this website mobile-first using bootstrap. I may also utilize CSS animations and AJAX if I am able. My planned tables are:

Useruser_iduser_emailuser_passworduser_saltuser_fnameuser_lnameuser_favorite_topicuser_bio
Topictopic_idtopic_nametopic_type
Postpost_idpost_topicpost_body
Commentcomment_idcomment_postcomment_body