/*
================================================================================
档案代号:vap_file
档案名称:aps(投料点)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vap_file
(
vap01       varchar2(40) DEFAULT '' NOT NULL, /*主件品号*/
vap02       varchar2(40) DEFAULT '' NOT NULL, /*元件品号*/
vap03       varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/
vap04       varchar2(60),            /*加工序号                               */
vap05       varchar2(6)              /*作业编号                               */
);

create unique index vap_pk on vap_file (vap01,vap02,vap03);
alter table vap_file add  constraint vap_pk primary key  (vap01,vap02,vap03) enable validate;
grant select on vap_file to public;
grant index on vap_file to public;
grant update on vap_file to public;
grant delete on vap_file to public;
grant insert on vap_file to public;