/*
================================================================================
档案代号:vng_file
档案名称:aps 制程外包维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vng_file
(
vng01       varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/
vng02       varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/
vng03       varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/
vng04       varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/
vng06       number(1),               /*外包类型                               */
vng07       date,                    /*开始时间(日期)                         */
vng08       date,                    /*结束时间(日期)                         */
vng10       number(1),               /*排程                                   */
vng11       number(9)                /*外包商序号                             */
);

create unique index vng_pk on vng_file (vng01,vng02,vng03,vng04);
alter table vng_file add  constraint vng_pk primary key  (vng01,vng02,vng03,vng04) enable validate;
grant select on vng_file to public;
grant index on vng_file to public;
grant update on vng_file to public;
grant delete on vng_file to public;
grant insert on vng_file to public;