/* ================================================================================ 档案代号:tsh_file 档案名称:集团转拨申请单单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tsh_file ( tsh01 varchar2(16) NOT NULL, /*调拨单号 */ /*调拨单号 tse01 */ tsh02 number(5) NOT NULL, /*项次 */ tsh03 varchar2(40), /*料件编号 */ tsh04 varchar2(4), /*单位 */ tsh05 number(20,6), /*数量 */ tsh06 number(20,6), /*核准数量 */ tsh07 varchar2(4), /*单位一 */ tsh08 number(20,8), /*单位一转换率 */ tsh09 number(15,3), /*单位一数量 */ tsh10 varchar2(4), /*单位二 */ tsh11 number(20,8), /*单位二转换率 */ tsh12 number(15,3), /*单位二数量 */ tsh13 varchar2(10) /*原因码 */ ); create unique index tsh_pk on tsh_file (tsh01,tsh02); alter table tsh_file add constraint tsh_pk primary key (tsh01,tsh02) enable validate; grant select on tsh_file to public; grant index on tsh_file to public; grant update on tsh_file to public; grant delete on tsh_file to public; grant insert on tsh_file to public; |