회원이랑 게시판

[회원 테이블]

CREATE TABLE members(
SEQ number(5) constraint member_num not null primary key,
 id varchar(15) not null,
 pass varchar(30) not null,
 name varchar(14) not null,
 email1 varchar(20) not null,
 email2 varchar(20) not null,
 sent varchar(5) not null,
 ph1 number(4) not null,
 ph2 number(4) not null,
 ph3 number(4) not null,
 gender varchar(15) not null,
 birth1 number(4) not null,
 birth2 number(4) not null,
 birth3 number(4) not null,
 address varchar(20) not null,
 regdate date not null
);

INSERT INTO members values(member_num.nextval,'1','2','3','4','5','6',7,8,9,'10',11,12,13,'서울시',sysdate);
CREATE SEQUENCE member_num
START WITH 1
increment by 1;

[게시판 테이블]

CREATE table article(
a_num number(100) primary key,
id varchar2(10) references member(id),
title varchar2(100),
contents varchar2(100),
hits number(100),
delete_sel varchar2(10),
time varchar2(50),
update_time varchar2(50)
);