/*
================================================================================
档案代号:pmv_file
档案名称:多属性料收货替代原则档
档案目的:多属性料收货替代原则档 假双档
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmv_file
(
pmv01       varchar2(40) DEFAULT '' NOT NULL, /*多属性母料号/多属性明细料号*/
pmv02       varchar2(10) DEFAULT '' NOT NULL, /*供应商编号,*号代表不区分供  */
pmv03       varchar2(10) DEFAULT '' NOT NULL, /*属性代码,放单身*/
pmv04       varchar2(255) DEFAULT '' NOT NULL, /*属性值 *号代表所有,放单身*/
pmv05       varchar2(255) DEFAULT '' NOT NULL, /*可替代属性值 *号代表所有,放 */
pmv06       varchar2(1) DEFAULT '' NOT NULL, /*同属性群组都可以替代否,若此*/
pmv07       varchar2(80),            /*属性值说明                             */
pmv08       varchar2(80),            /*可替代属性值说明                       */
pmv09       date DEFAULT sysdate NOT NULL, /*生效日期,放单身*/
pmv10       date                     /*失效日期,放单身                        */
);

create unique index pmv_pk on pmv_file (pmv01,pmv02,pmv03,pmv04,pmv05,pmv06);
alter table pmv_file add  constraint pmv_pk primary key  (pmv01,pmv02,pmv03,pmv04,pmv05,pmv06) enable 
validate;
grant select on pmv_file to public;
grant index on pmv_file to public;
grant update on pmv_file to public;
grant delete on pmv_file to public;
grant insert on pmv_file to public;