/*
================================================================================
档案代号:pmu_file
档案名称:一般料号收货替代原则档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmu_file
(
pmu01       varchar2(40) DEFAULT '' NOT NULL, /*料号*/
pmu02       varchar2(10) DEFAULT '' NOT NULL, /*供应商,*号代表不区分供应商, */
pmu03       number(5) DEFAULT '0' NOT NULL, /*起始码*/
pmu04       number(5) DEFAULT '0' NOT NULL, /*截至码*/
pmu05       varchar2(10) DEFAULT '' NOT NULL, /*原值*/
pmu06       varchar2(10) DEFAULT '' NOT NULL, /*替代值*/
pmu07       date DEFAULT sysdate NOT NULL, /*生效日期*/
pmu08       date                     /*失效日期                               */
);

create unique index pmu_pk on pmu_file (pmu01,pmu02,pmu03,pmu04,pmu05,pmu06,pmu07);
alter table pmu_file add  constraint pmu_pk primary key  (pmu01,pmu02,pmu03,pmu04,pmu05,pmu06,pmu07) enable 
validate;
grant select on pmu_file to public;
grant index on pmu_file to public;
grant update on pmu_file to public;
grant delete on pmu_file to public;
grant insert on pmu_file to public;