/*
================================================================================
档案代号:vnd_file
档案名称:aps 锁定制程时间维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vnd_file
(
vnd01       varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/
vnd02       varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/
vnd03       varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/
vnd04       varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/
vnd05       varchar2(10) NOT NULL,   /*资源编号                               */
vnd06       number(1),               /*锁定码                                 */
vnd07       date,                    /*开始时间                               */
vnd08       date,                    /*结束时间                               */
vnd09       number(1),               /*排程                                   */
vnd10       number(1)                /*是否为平行机台任务                     */
);

create unique index vnd_pk on vnd_file (vnd01,vnd02,vnd03,vnd04,vnd05);
alter table vnd_file add  constraint vnd_pk primary key  (vnd01,vnd02,vnd03,vnd04,vnd05) enable validate;
grant select on vnd_file to public;
grant index on vnd_file to public;
grant update on vnd_file to public;
grant delete on vnd_file to public;
grant insert on vnd_file to public;