CREATE
TABLE
sysmanage.TB_DATA_DEAL_STATUS (
SERIAL_NO integer NOT NULL , -- 自动增长,要建1个增长序列,如下
DATA_TYPE char ( 1 ) NOT NULL ,
DATA_UNIT_TYPE char ( 1 ) NOT NULL ,
DATA_UNIT_CODE char ( 4 ) NOT NULL ,
DATA_DATE char ( 8 ) NOT NULL ,
REQUEST_CODE integer NOT NULL ,
BATCH_NO char ( 2 ) NOT NULL ,
STATUS char ( 1 )
)
tablespace ts_sysmanage; -- 表空间
create sequence KMMS.SEQ_DATA_DEAL_STATUS ---增长序列相当于indentity
minvalue 1
maxvalue 99999999999999999999999999
start with 1
increment by 1
cache 20 ;
SERIAL_NO integer NOT NULL , -- 自动增长,要建1个增长序列,如下
DATA_TYPE char ( 1 ) NOT NULL ,
DATA_UNIT_TYPE char ( 1 ) NOT NULL ,
DATA_UNIT_CODE char ( 4 ) NOT NULL ,
DATA_DATE char ( 8 ) NOT NULL ,
REQUEST_CODE integer NOT NULL ,
BATCH_NO char ( 2 ) NOT NULL ,
STATUS char ( 1 )
)
tablespace ts_sysmanage; -- 表空间
create sequence KMMS.SEQ_DATA_DEAL_STATUS ---增长序列相当于indentity
minvalue 1
maxvalue 99999999999999999999999999
start with 1
increment by 1
cache 20 ;