/*
================================================================================
档案代号:vav_file
档案名称:aps(需求订单选配)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vav_file
(
vav01       varchar2(40) DEFAULT '' NOT NULL, /*option 件料号*/
vav02       varchar2(40) DEFAULT '' NOT NULL, /*feature件料号*/
vav03       varchar2(60) DEFAULT '' NOT NULL, /*需求订单编号*/
vav04       varchar2(60) DEFAULT '' NOT NULL /*元件序号*/
);

create unique index vav_pk on vav_file (vav01,vav02,vav03,vav04);
alter table vav_file add  constraint vav_pk primary key  (vav01,vav02,vav03,vav04) enable validate;
grant select on vav_file to public;
grant index on vav_file to public;
grant update on vav_file to public;
grant delete on vav_file to public;
grant insert on vav_file to public;