DDL
CREATE TABLE User
(
userIdx INT NOT NULL AUTO_INCREMENT,
nickName VARCHAR(45) NOT NULL COMMENT '유저이름',
name VARCHAR(45) NOT NULL COMMENT '유저 닉네임',
profileImgUrl TEXT NOT NULL COMMENT '유저 프로필 사진',
website VARCHAR(45) NULL COMMENT '유저 웹사이트',
introduce VARCHAR(45) NULL COMMENT '유저 소개',
status VARCHAR(10) NOT NULL DEFAULT 'ACTIVE' COMMENT 'ACTIVE : 활성화 INACTIVE : 비활성화 DELETED : 삭제된 계정',
createdAt TIMESTAMP NOT NULL DEFAULT current_timestamp,
updatedAt TIMESTAMP NOT NULL DEFAULT current_timestamp on update current_timestamp,
PRIMARY KEY (userIdx)
);
ALTER TABLE User COMMENT '유저 테이블';
CREATE TABLE Post
(
postIdx INT NOT NULL AUTO_INCREMENT,
userIdx INT NOT NULL,
content VARCHAR(45) NOT NULL,
status VARCHAR(10) NOT NULL DEFAULT 'ACTIVE' COMMENT 'ACTIVE : 활성화 INACTIVE : 비활성화 DELETED : 삭제된 계정',
createdAt TIMESTAMP NOT NULL DEFAULT current_timestamp,
updatedAt TIMESTAMP NOT NULL DEFAULT current_timestamp on update current_timestamp,
PRIMARY KEY (postIdx)
);
ALTER TABLE Post COMMENT '게시물 테이블';
CREATE TABLE PostImgUrl
(
postImgIdx INT NOT NULL AUTO_INCREMENT,
postIdx INT NOT NULL,
imgUrl TEXT NOT NULL,
status VARCHAR(10) NOT NULL DEFAULT 'ACTIVE' COMMENT 'ACTIVE : 활성화 INACTIVE : 비활성화 DELETED : 삭제된 계정',
createdAt TIMESTAMP NOT NULL DEFAULT current_timestamp,
updatedAt TIMESTAMP NOT NULL DEFAULT current_timestamp on update current_timestamp,
PRIMARY KEY (postImgIdx)
);
ALTER TABLE PostImgUrl COMMENT '게시물 사진 테이블';
CREATE TABLE Comment
(
commentIdx INT NOT NULL AUTO_INCREMENT,
userIdx INT NOT NULL,
postIdx INT NOT NULL,
content VARCHAR(100) NOT NULL,
parentCommentIdx INT NOT NULL DEFAULT 0,
status VARCHAR(10) NOT NULL DEFAULT 'ACTIVE' COMMENT 'ACTIVE : 활성화 INACTIVE : 비활성화 DELETED : 삭제된 계정',
createdAt TIMESTAMP NOT NULL DEFAULT current_timestamp,
updatedAt TIMESTAMP NOT NULL DEFAULT current_timestamp on update current_timestamp,
PRIMARY KEY (commentIdx)
);
ALTER TABLE Comment COMMENT '댓글테이블';
CREATE TABLE Follow
(
followIdx INT NOT NULL AUTO_INCREMENT,
followerIdx INT NOT NULL,
followeeIdx INT NOT NULL,
status VARCHAR(10) NOT NULL DEFAULT 'ACTIVE' COMMENT 'ACTIVE: 팔로우 INACTIVE : 언팔',
createdAt TIMESTAMP NOT NULL DEFAULT current_timestamp,
updatedAt TIMESTAMP NOT NULL DEFAULT current_timestamp on update current_timestamp,
PRIMARY KEY (followIdx)
);
ALTER TABLE Follow COMMENT '팔로우 테이블';
