*this info is subject to change before heroku deploy
postgreSQL-db structure:
- create table sw_article (article_id serial primary key on delete cascade, writer_ip inet, article_content varchar(200), article_time timestamp, article_password varchar(60));
- create table sw_score (score_id serial primary key, scorer_ip inet, score int not null check(score = 1 or score = -1), article_id integer references sw_article(article_id) on delete cascade);
- create table sw_comment (comment_id serial primary key, commenter_ip inet, article_id integer references sw_article(article_id) on delete cascade, comment_content varchar(150), comment_password varchar(60));
note:
- npm 'pg' is very verbose. always stick to 'pg-promise' unless it's necessary.
- db structure should be planned ahead on note, so that later alteration is not necessary.
- never forget to include gitignore...it is real pain in the ass.
- bcrypt hash is made of 60 letters => varchar(60)