ALTER TABLE ARTICLE
DROP
CONSTRAINT FK_ARTICLE_TO_ARTICLE
CASCADE;
ALTER TABLE ARTICLE
DROP
CONSTRAINT FK_BOARD_TO_ARTICLE
CASCADE;
ALTER TABLE reply
DROP
CONSTRAINT FK_ARTICLE_TO_reply
CASCADE;
ALTER TABLE attach
DROP
CONSTRAINT FK_ARTICLE_TO_attach
CASCADE;
ALTER TABLE ARTICLE
DROP
PRIMARY KEY
CASCADE
KEEP INDEX;
ALTER TABLE user7
DROP
PRIMARY KEY
CASCADE
KEEP INDEX;
ALTER TABLE reply
DROP
PRIMARY KEY
CASCADE
KEEP INDEX;
ALTER TABLE attach
DROP
PRIMARY KEY
CASCADE
KEEP INDEX;
ALTER TABLE BOARD
DROP
PRIMARY KEY
CASCADE
KEEP INDEX;
/* 게시글 */
CREATE TABLE ARTICLE (
ARTICLECODE VARCHAR2(200) NOT NULL, /* 게시글코드 */
BOARDCODE VARCHAR2(200) NOT NULL, /* 게시판분류 */
ARTICLETITLE VARCHAR2(200), /* 제목 */
ARTICLECONTENT VARCHAR2(1000) NOT NULL, /* 내용 */
ARTICLEDATE DATE NOT NULL, /* 등록날짜 */
ARTICLEDELETE VARCHAR2(200) NOT NULL, /* 삭제여부 */
ARTICLEUPPER VARCHAR2(200), /* 상위게시글코드 */
ID VARCHAR2(200) /* 사용자아이디 */
);
ALTER TABLE ARTICLE
ADD
CONSTRAINT PK_ARTICLE
PRIMARY KEY (
ARTICLECODE
);
/* 전체회원정보 */
CREATE TABLE user7 (
ID VARCHAR2(200) NOT NULL, /* 사용자아이디 */
NAME VARCHAR2(200) NOT NULL, /* 사용자이름 */
PASS NUMBER NOT NULL /* 사용자비밀번호 */
);
ALTER TABLE user7
ADD
CONSTRAINT PK_user7
PRIMARY KEY (
ID
);
/* 댓글 */
CREATE TABLE reply (
REPLYCODE VARCHAR2(200) NOT NULL, /* 댓글코드 */
ARTICLECODE VARCHAR2(200) NOT NULL, /* 게시글코드 */
REPLYCONTENT VARCHAR2(500) NOT NULL, /* 내용 */
REPLYDATE DATE NOT NULL, /* 등록날짜 */
REPLYDELETE VARCHAR2(200) NOT NULL /* 삭제여부 */
);
ALTER TABLE reply
ADD
CONSTRAINT PK_reply
PRIMARY KEY (
REPLYCODE
);
/* 첨부파일 */
CREATE TABLE attach (
FILECODE VARCHAR2(200) NOT NULL, /* 첨부파일코드 */
ARTICLE_CODE VARCHAR2(200) NOT NULL, /* 게시글코드 */
ATTACHNAME VARCHAR2(500) /* 첨부파일명 */
);
ALTER TABLE attach
ADD
CONSTRAINT PK_attach
PRIMARY KEY (
FILECODE
);
/* 게시판 */
CREATE TABLE BOARD (
BOARDCODE VARCHAR2(200) NOT NULL, /* 게시판분류 */
STATUS VARCHAR2(200) NOT NULL /* 비활성화여부 */
);
ALTER TABLE BOARD
ADD
CONSTRAINT PK_BOARD
PRIMARY KEY (
BOARDCODE
);
ALTER TABLE ARTICLE
ADD
CONSTRAINT FK_ARTICLE_TO_ARTICLE
FOREIGN KEY (
ARTICLEUPPER
)
REFERENCES ARTICLE (
ARTICLECODE
) on delete cascade ;
ALTER TABLE ARTICLE
ADD
CONSTRAINT FK_BOARD_TO_ARTICLE
FOREIGN KEY (
BOARDCODE
)
REFERENCES BOARD (
BOARDCODE
) on delete cascade ;
ALTER TABLE reply
ADD
CONSTRAINT FK_ARTICLE_TO_reply
FOREIGN KEY (
ARTICLECODE
)
REFERENCES ARTICLE (
ARTICLECODE
) on delete cascade ;
ALTER TABLE attach
ADD
CONSTRAINT FK_ARTICLE_TO_attach
FOREIGN KEY (
ARTICLE_CODE
)
REFERENCES ARTICLE (
ARTICLECODE
) on delete cascade ;
댓글
댓글 쓰기