/* ================================================================================ 档案代号:shq_file 档案名称:RUN CARD分割资料单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table shq_file ( shq01 varchar2(16) NOT NULL, /*分割单号 */ shq011 number(5) NOT NULL, /*分割序号 */ shq02 varchar2(19), /*新Run Card */ shq03 number(15,3), /*拆批数量 */ shq04 varchar2(255), /*备注 */ shq05 varchar2(1), /*No Use */ shq06 varchar2(1), /*No Use */ shq07 varchar2(1), /*No Use */ shq08 varchar2(1), /*No Use */ shq09 varchar2(1), /*No Use */ shq10 varchar2(1) /*No Use */ ); create index shq_02 on shq_file (shq03); create unique index shq_pk on shq_file (shq01,shq011); alter table shq_file add constraint shq_pk primary key (shq01,shq011) enable validate; grant select on shq_file to public; grant index on shq_file to public; grant update on shq_file to public; grant delete on shq_file to public; grant insert on shq_file to public; |