/* ================================================================================ 档案代号:tsl_file 档案名称:集团转拨申请单单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tsl_file ( tsl01 varchar2(16) NOT NULL, /*调拨单号 */ /*调拨单号 tsk01 */ tsl02 number(5) NOT NULL, /*项次 */ tsl03 varchar2(40), /*料件编号 */ tsl04 varchar2(4), /*单位 */ tsl05 number(20,6), /*数量 */ tsl06 number(20,6), /*回报数量 */ tsl07 varchar2(4), /*单位一 */ tsl08 number(20,8), /*单位一转换率 */ tsl09 number(15,3), /*单位一数量 */ tsl10 varchar2(4), /*单位二 */ tsl11 number(20,8), /*单位二转换率 */ tsl12 number(15,3) /*单位二数量 */ ); create unique index tsl_pk on tsl_file (tsl01,tsl02); alter table tsl_file add constraint tsl_pk primary key (tsl01,tsl02) enable validate; grant select on tsl_file to public; grant index on tsl_file to public; grant update on tsl_file to public; grant delete on tsl_file to public; grant insert on tsl_file to public; |