/*
================================================================================
档案代号:vne_file
档案名称:aps 锁定使用设备维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vne_file
(
vne01       varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/
vne02       varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/
vne03       varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/
vne04       varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/
vne05       varchar2(10) DEFAULT '' NOT NULL, /*资源编号*/
vne06       number(15,3),            /*生产数量                               */
vne07       number(1)                /*排程                                   */
);

create unique index vne_pk on vne_file (vne01,vne02,vne03,vne04,vne05);
alter table vne_file add  constraint vne_pk primary key  (vne01,vne02,vne03,vne04,vne05) enable validate;
grant select on vne_file to public;
grant index on vne_file to public;
grant update on vne_file to public;
grant delete on vne_file to public;
grant insert on vne_file to public;