커뮤니티 게시판 Lv.1 - 데이터모델링

DROP DATABASE IF EXISTS `community`; CREATE DATABASE `community` DEFAULT CHARACTER SET = 'utf8mb4';

DROP TABLE IF EXISTS `files`; DROP TABLE IF EXISTS `comments`; DROP TABLE IF EXISTS `posts`; DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `no` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, `id` VARCHAR(64) NOT NULL, `username` VARCHAR(100) NOT NULL, `password` VARCHAR(100) NOT NULL, `name` VARCHAR(50) NOT NULL, `email` VARCHAR(200) NOT NULL, `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE `posts` ( `no` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, `id` VARCHAR(64) NOT NULL, `user_no` BIGINT NOT NULL, `title` VARCHAR(200) NOT NULL, `content` TEXT, `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (`user_no`) REFERENCES `users` (`no`) ); CREATE TABLE `comments` ( `no` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, `id` VARCHAR(64) NOT NULL, `post_no` BIGINT NOT NULL, `user_no` BIGINT NOT NULL, `content` TEXT NOT NULL, `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (`post_no`) REFERENCES `posts` (`no`), FOREIGN KEY (`user_no`) REFERENCES `users` (`no`) ); CREATE TABLE `files` ( `no` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, `id` VARCHAR(64) NOT NULL, `post_no` BIGINT NOT NULL, `file_name` VARCHAR(100) NOT NULL, `file_path` VARCHAR(2000) NOT NULL, `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (`post_no`) REFERENCES `posts` (`no`) );