/* ================================================================================ 档案代号:zj_file 档案名称:批次执行指令明细档 BATCH INSTRUCTIO 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zj_file ( zj01 varchar2(10) NOT NULL, /*批次编号 */ zj02 number(5) NOT NULL, /*序号 */ zj03 varchar2(10), /*指令编号 */ zj041 varchar2(72), /*指令内容 ( 一 ) */ zj042 varchar2(72), /*指令内容 ( 二 ) */ zj043 varchar2(72) /*指令内容 ( 三 ) */ ); create unique index zj_pk on zj_file (zj01,zj02); alter table zj_file add constraint zj_pk primary key (zj01,zj02) enable validate; grant select on zj_file to public; grant index on zj_file to public; grant update on zj_file to public; grant delete on zj_file to public; grant insert on zj_file to public; |