[BE] Omoklens DDL ver.0.2

[orlzlL]

패치노트

• omokevent 테이블에 TITLE 컬럼이 추가되었습니다.

CREATE TABLE `member`
(
    `MEMBER_ID`    VARCHAR(20) NOT NULL,
    `NAME`    VARCHAR(30) NOT NULL,
    `NICKNAME`    VARCHAR(20),
    `PASSWORD`    VARCHAR(255) NOT NULL,
    `EMAIL`    VARCHAR(40),
    `PHONE_NUM`    VARCHAR(11),
    `ADDRESS`    VARCHAR(255),
    `BIRTHDAY`    VARCHAR(30),
    `SIGN_UP_DATE`    VARCHAR(30) NOT NULL,
    `IS_WITHDRAW`    BOOLEAN DEFAULT false NOT NULL,
 PRIMARY KEY ( `MEMBER_ID` )
);


CREATE TABLE `omokevent`
(
    `OMOKEVENT_ID`    INTEGER NOT NULL AUTO_INCREMENT,
    `TITLE` VARCHAR(255) NOT NULL,
    `ORGANIZATION`    VARCHAR(255) NOT NULL,
    `CATEGORY`    VARCHAR(255) NOT NULL,
    `TARGET_PARTICIPANT`    VARCHAR(255),
    `APPLY_START_DATE`    VARCHAR(255) DEFAULT '미정' NOT NULL,
    `APPLY_END_DATE`    VARCHAR(255) DEFAULT '미정' NOT NULL,
    `JUDGE_START_DATE`    VARCHAR(255) DEFAULT '미정' NOT NULL,
    `JUDGE_END_DATE`    VARCHAR(255) DEFAULT '미정' NOT NULL,
    `ANOUNCEMENT_DATE`    VARCHAR(255) DEFAULT '미정' NOT NULL,
    `LOCATION`    VARCHAR(255),
    `AWARD`    VARCHAR(255),
    `APPLY_PROCESS`    VARCHAR(255) NOT NULL,
    `APPLY_FEE`    VARCHAR(255) DEFAULT '0' NOT NULL,
    `HOMEPAGE`    VARCHAR(255) NOT NULL,
    `POST_IMAGE`    VARCHAR(255),
    `CONTENT`    LONGTEXT NOT NULL,
    `HITS`    INTEGER DEFAULT 0 NOT NULL,
    `STATUS` VARCHAR(255) NOT NULL,
 PRIMARY KEY ( `OMOKEVENT_ID` )
);


CREATE TABLE `bookmark`
(
    `BOOKMARK_ID`    INTEGER NOT NULL AUTO_INCREMENT,
    `IS_BOOKMARK`    BOOLEAN NOT NULL,
    `OMOKEVENT_ID`    INTEGER NOT NULL,
    `MEMBER_ID`    VARCHAR(20) NOT NULL,
 PRIMARY KEY ( `BOOKMARK_ID` )
);


CREATE TABLE `comment`
(
    `COMMENT_ID`    INTEGER NOT NULL AUTO_INCREMENT,
    `CONTENT`    LONGTEXT NOT NULL,
    `POSTED_DATE`    VARCHAR(255) DEFAULT now() NOT NULL,
    `LAST_MODIFIED_DATE`    VARCHAR(255) DEFAULT now() NOT NULL,
    `IS_DELETED`    BOOLEAN DEFAULT false NOT NULL,
    `COMMENT_CATEGORY`    VARCHAR(255) DEFAULT 'event' NOT NULL,
    `OMOKEVENT_ID`    INTEGER NOT NULL,
    `MEMBER_ID`    VARCHAR(20) NOT NULL,
 PRIMARY KEY ( `COMMENT_ID` )
);




ALTER TABLE `bookmark`
 ADD CONSTRAINT `bookmark_FK` FOREIGN KEY ( `OMOKEVENT_ID` )
 REFERENCES `omokevent` (`OMOKEVENT_ID` );

ALTER TABLE `bookmark`
 ADD CONSTRAINT `bookmark_FK1` FOREIGN KEY ( `MEMBER_ID` )
 REFERENCES `member` (`MEMBER_ID` );



ALTER TABLE `comment`
 ADD CONSTRAINT `comment_FK` FOREIGN KEY ( `MEMBER_ID` )
 REFERENCES `member` (`MEMBER_ID` );

ALTER TABLE `comment`
 ADD CONSTRAINT `comment_FK1` FOREIGN KEY ( `OMOKEVENT_ID` )
 REFERENCES `omokevent` (`OMOKEVENT_ID` );