/*
================================================================================
档案代号:vbd_file
档案名称:aps(锁定制程时间)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vbd_file
(
vbd01       varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/
vbd02       varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/
vbd03       varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/
vbd04       varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/
vbd05       varchar2(10) DEFAULT '' NOT NULL, /*资源编号*/
vbd06       number(1),               /*锁定码                                 */
vbd07       date,                    /*开始时间 to_date('2006-07-03 00:00:0   */
vbd08       date,                    /*结束时间 to_date('2006-07-03 00:00:0   */
vbd09       number(1),               /*排程                                   */
vbd10       number(1)                /*平行机台任务                           */
);

create unique index vbd_pk on vbd_file (vbd01,vbd02,vbd03,vbd04,vbd05);
alter table vbd_file add  constraint vbd_pk primary key  (vbd01,vbd02,vbd03,vbd04,vbd05) enable validate;
grant select on vbd_file to public;
grant index on vbd_file to public;
grant update on vbd_file to public;
grant delete on vbd_file to public;
grant insert on vbd_file to public;