/*
================================================================================
档案代号:stw_file
档案名称:差异分摊基本资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table stw_file
(
stw01       varchar2(1) NOT NULL,    /*类别                                   */
                                     /*类别:1:材料 2:成品 3:半成品            */
stw02       varchar2(10) NOT NULL,   /*产品别                                 */
stw03       number(20,6)             /*差异金额                               */
);

create unique index stw_pk on stw_file (stw01,stw02);
alter table stw_file add  constraint stw_pk primary key  (stw01,stw02) enable validate;
grant select on stw_file to public;
grant index on stw_file to public;
grant update on stw_file to public;
grant delete on stw_file to public;
grant insert on stw_file to public;