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:
User | user_id | user_email | user_password | user_salt | user_fname | user_lname | user_favorite_topic | user_bio |
Topic | topic_id | topic_name | topic_type | |||||
Post | post_id | post_topic | post_body | |||||
Comment | comment_id | comment_post | comment_body |