/*
================================================================================
档案代号: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;