내용

글번호 845
작성자 heojk
작성일 2022-10-27 14:12:34
제목 멀티 게시판 테이블 생성문
내용 DROP TABLE BOARD_UPLOAD_FILE; DROP TABLE BOARD; DROP TABLE BOARD_CATEGORY; CREATE TABLE BOARD ( BOARD_ID NUMBER CONSTRAINT PK_BOARD_BOARD_ID PRIMARY KEY, CATEGORY_ID NUMBER, WRITER VARCHAR2(20) NOT NULL, EMAIL VARCHAR2(100), PASSWORD VARCHAR2(20) NOT NULL, TITLE VARCHAR2(500) NOT NULL, CONTENT CLOB, WRITE_DATE DATE DEFAULT SYSDATE NOT NULL, MASTER_ID NUMBER, REPLY_NUMBER NUMBER, REPLY_STEP NUMBER, READ_COUNT NUMBER DEFAULT 0 ); CREATE TABLE BOARD_CATEGORY ( CATEGORY_ID NUMBER CONSTRAINT PK_BOARD_CATEGORY_ID PRIMARY KEY, CATEGORY_NAME VARCHAR2(100) NOT NULL, CATEGORY_CLASS1 NUMBER(4) NULL, CATEGORY_CLASS2 NUMBER(4) NULL, CATEGORY_DESCRIPTION VARCHAR2(100) NULL, CATEGORY_ORDER NUMBER(4) NULL ) ; CREATE TABLE BOARD_UPLOAD_FILE ( FILE_ID NUMBER CONSTRAINT PK_BOARD_FILE_ID PRIMARY KEY, BOARD_ID NUMBER NULL, FILE_NAME VARCHAR2(235) NULL, FILE_SIZE VARCHAR2(45) NULL, FILE_CONTENT_TYPE VARCHAR2(500) NULL, FILE_DATA BLOB NULL ) ; ALTER TABLE BOARD_CATEGORY ADD CONSTRAINT UK_BOARD_CATEGORY_NAME UNIQUE (CATEGORY_NAME) USING INDEX ; ALTER TABLE BOARD ADD CONSTRAINT FK_BOARD_CATEGORY_ID FOREIGN KEY (CATEGORY_ID) REFERENCES BOARD_CATEGORY (CATEGORY_ID) ; ALTER TABLE BOARD_UPLOAD_FILE ADD CONSTRAINT FK_BOARD_BOARD_ID FOREIGN KEY (BOARD_ID) REFERENCES BOARD (BOARD_ID) ; INSERT INTO BOARD_CATEGORY (CATEGORY_ID, CATEGORY_NAME, CATEGORY_CLASS1, CATEGORY_CLASS2, CATEGORY_DESCRIPTION, CATEGORY_ORDER) VALUES(SEQ_BOARD_CATEGORY_ID.NEXTVAL, '게시판', 1, 11, '게시판', 100); INSERT INTO BOARD_CATEGORY (CATEGORY_ID, CATEGORY_NAME, CATEGORY_CLASS1, CATEGORY_CLASS2, CATEGORY_DESCRIPTION, CATEGORY_ORDER) VALUES(SEQ_BOARD_CATEGORY_ID.NEXTVAL, '자료실', 2, 21, '자료실', 200); INSERT INTO BOARD_CATEGORY (CATEGORY_ID, CATEGORY_NAME, CATEGORY_CLASS1, CATEGORY_CLASS2, CATEGORY_DESCRIPTION, CATEGORY_ORDER) VALUES(SEQ_BOARD_CATEGORY_ID.NEXTVAL, '겔러리', 3, 31, '겔러리', 300); COMMIT; DROP TABLE MEMBER; CREATE TABLE MEMBER ( USERID VARCHAR2(50) CONSTRAINT PK_MEMBER PRIMARY KEY, NAME VARCHAR2(50) NOT NULL, PASSWORD VARCHAR2(50) NOT NULL, EMAIL VARCHAR2(100) NOT NULL, PHONE VARCHAR2(50) ) ; ALTER TABLE MEMBER ADD CONSTRAINT UK_MEMBER_EMAIL UNIQUE (EMAIL) USING INDEX ;