/*
================================================================================
档案代号:val_file
档案名称:aps品项分配法则
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table val_file
(
val01       varchar2(40) DEFAULT '' NOT NULL, /*完成品料号*/
val02       varchar2(60) DEFAULT '' NOT NULL, /*分配法则编号*/
val03       varchar2(40) DEFAULT '' NOT NULL, /*为part_id本身或其下阶料号*/
val04       varchar2(60) DEFAULT '' NOT NULL /*供给法则编号*/
);

create unique index val_pk on val_file (val01,val02,val03,val04);
alter table val_file add  constraint val_pk primary key  (val01,val02,val03,val04) enable validate;
grant select on val_file to public;
grant index on val_file to public;
grant update on val_file to public;
grant delete on val_file to public;
grant insert on val_file to public;