Full-stack - Node.js, HTML, MySQL - social media application.
$ npm start
CREATE TABLE `socialdb`.`tb_posts` ( `post_id` INT NOT NULL AUTO_INCREMENT , `author_id` INT NOT NULL , `title` TINYTEXT NOT NULL,`text` TEXT NOT NULL , `no_likes` INT NOT NULL DEFAULT '0' , `no_comments` INT NOT NULL DEFAULT '0' , `is_deleted` BOOLEAN NOT NULL DEFAULT FALSE , `creation_datetime` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `updated_datetime` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`post_id`), INDEX (`creation_datetime`), INDEX (`author_id`), FULLTEXT (`title`)) ENGINE = InnoDB;CREATE TABLE `socialdb`.`tb_comments` ( `comment_id` INT NOT NULL AUTO_INCREMENT , `post_id` INT NOT NULL , `author_id` INT NOT NULL , `text` TEXT NOT NULL , `no_likes` INT NOT NULL DEFAULT '0' , `is_deleted` BOOLEAN NOT NULL DEFAULT FALSE , `creation_datetime` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `updated_datetime` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`comment_id`), INDEX (`post_id`), INDEX (`creation_datetime`)) ENGINE = InnoDB;CREATE TABLE `socialdb`.`tb_follow_relationship` ( `relation_id` INT NOT NULL AUTO_INCREMENT , `user_id` INT NOT NULL , `followed_id` INT NOT NULL , `is_followed` BOOLEAN NOT NULL DEFAULT TRUE , `creation_datetime` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `updated_datetime` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`relation_id`), INDEX (`creation_datetime`), INDEX (`user_id`), INDEX (`followed_id`)) ENGINE = InnoDB;CREATE TABLE `socialdb`.`tb_users` ( `user_id` INT NOT NULL AUTO_INCREMENT , `first_name` VARCHAR(50) NOT NULL , `last_name` VARCHAR(50) NULL DEFAULT NULL , `password` TINYTEXT NOT NULL , `username` VARCHAR(40) NOT NULL , `phone` VARCHAR(10) NULL DEFAULT NULL , `email` TINYTEXT NULL DEFAULT NULL , `bio` TINYTEXT NULL, `is_active` BOOLEAN NOT NULL DEFAULT TRUE , `is_private` BOOLEAN NOT NULL DEFAULT FALSE,`creation_datetime` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `updated_datetime` DATETIME on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`user_id`), UNIQUE (`username`)) ENGINE = InnoDB;CREATE TABLE `socialdb`.`tb_like_relationship` ( `like_id` INT NOT NULL AUTO_INCREMENT , `post_id` INT NOT NULL , `user_id` INT NOT NULL , PRIMARY KEY (`like_id`), INDEX (`post_id`), INDEX (`user_id`)) ENGINE = InnoDB;CREATE TABLE `socialdb`.`tb_comment_relationship` ( `comment_like_id` INT NOT NULL AUTO_INCREMENT , `comment_id` INT NOT NULL , `user_id` INT NOT NULL , PRIMARY KEY (`comment_like_id`), INDEX (`comment_id`), INDEX (`user_id`)) ENGINE = InnoDB;