/* ================================================================================ 档案代号:sth_file 档案名称:每月工单投入人工,制费明细档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table sth_file ( sth01 number(5), /*年度 */ sth02 number(5), /*月份 */ sth03 varchar2(16), /*工单号码 */ sth04 number(20,6), /*投入人工 */ sth05 number(20,6), /*投入制费一 */ sth06 number(20,6), /*投入制费二 */ sth07 number(20,6) /*投入加工费用 */ ); create index sth_01 on sth_file (sth01,sth02,sth03); grant select on sth_file to public; grant index on sth_file to public; grant update on sth_file to public; grant delete on sth_file to public; grant insert on sth_file to public; |