ITS_OP/SRC/SQL/시퀀스.sql

DROP SEQUENCE SC_TRAN_SEQ;

CREATE SEQUENCE SC_TRAN_SEQ
START WITH 1606
INCREMENT BY 1
MINVALUE 1
MAXVALUE 99999999
CYCLE 
CACHE 20
NOORDER ;


DROP SEQUENCE SQ_INCD_ID;

CREATE SEQUENCE SQ_INCD_ID
START WITH 20
INCREMENT BY 1
MINVALUE 0
MAXVALUE 999999999
CYCLE 
NOCACHE 
NOORDER ;


DROP SEQUENCE REPLY_SEQ;

CREATE SEQUENCE REPLY_SEQ
START WITH 44
INCREMENT BY 1
MINVALUE 1
MAXVALUE 999999999
NOCYCLE 
NOCACHE 
NOORDER ;


DROP SEQUENCE BOARD_SEQ;

CREATE SEQUENCE BOARD_SEQ
START WITH 87
INCREMENT BY 1
MINVALUE 1
MAXVALUE 999999999
NOCYCLE 
NOCACHE 
NOORDER ;