자료실 테이블
— 2015.04.07
CREATE TABLE databoard(
no NUMBER,
name VARCHAR2(34) CONSTRAINT db_nn_name NOT NULL,
subject VARCHAR2(1000) CONSTRAINT db_nn_subject NOT NULL,
content CLOB CONSTRAINT db_nn_content NOT NULL,
pwd VARCHAR2(10) constraint db_nn_pwd NOT NULL,
regdate DATE default sysdate,
hit number default 0,
filename VARCHAR2(260),
filesize NUMBER,
CONSTRAINT db_no_pk PRIMARY KEY(no)
);
COMMIT;