▣ 테이블 생성 > JSP2

• 목록

CREATE TABLE MEMBER (

M_ID VARCHAR2(20) primary key not null,

M_PASS VARCHAR2(20) not null,

M_NAME VARCHAR2(10) not null,

M_EMAIL VARCHAR2(70) not null,

M_LEVEL VARCHAR2(2) default '1',

SIGNDATE DATE default sysdate

);

CREATE TABLE notice ( 

bno number NOT NULL PRIMARY KEY,

id varchar2(20) NOT NULL,

name varchar2(20) NOT NULL,

subject varchar2(255) NOT NULL,

content LONG,

signdate TIMESTAMP default sysdate,

ref number DEFAULT 0,

gongji CHAR(1) DEFAULT '2',

file1 varchar2(100),

file1_s varchar(100),

fid number default 1,

thread varchar2(20) DEFAULT 'A'

) ;

CREATE TABLE gallery ( 

bno number NOT NULL PRIMARY KEY,

id varchar2(20) NOT NULL,

name varchar2(20) NOT NULL,

subject varchar2(255) NOT NULL,

content LONG,

signdate TIMESTAMP default sysdate,

ref number DEFAULT 0,

gongji CHAR(1) DEFAULT '2',

file1 varchar2(100),

file1_s varchar(100),

fid number default 1,

thread varchar2(20) DEFAULT 'A'

) ;

-- 값을 제외한 부분은 대,소문자 상관 없습니다.--