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

create unique index vml_pk on vml_file (vml01,vml02,vml03,vml04);
alter table vml_file add  constraint vml_pk primary key  (vml01,vml02,vml03,vml04) enable validate;
grant select on vml_file to public;
grant index on vml_file to public;
grant update on vml_file to public;
grant delete on vml_file to public;
grant insert on vml_file to public;