oracle table 생성, 시퀀스 생성

/* table 생성 */
create table noticereply(
rno number not null primary key,
bno number,
replytext varchar2(4000) not null,
replyer varchar2(50) not null,
regdate date default sysdate,
updatedate date default sysdate
);

alter table noticereply add constraint notice_board
foreign key(bno) references noticeboard2(bno);

/* 시퀀스 생성 */
create sequence noticereply_seq
start with 1 increment by 1
maxvalue 99999
nocycle;