/*
================================================================================
档案代号:vop_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vop_file
(
vop00       varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/
vop01       varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/
vop02       varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/
vop03       varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/
vop04       varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/
vop05       varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/
vop06       varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/
vop07       varchar2(10),            /*外包商编号                             */
vop08       number(1),               /*外包类型                               */
vop09       date,                    /*开始时间(日期)                         */
vop10       date,                    /*结束时间(日期)                         */
vop11       number(9),               /*作业时间                               */
vop12       number(1),               /*排程                                   */
vop13       number(5),               /*外包商序号                             */
vop14       number(15,3)             /*外包数量                               */
);

create unique index vop_pk on vop_file (vop00,vop01,vop02,vop03,vop04,vop05,vop06);
alter table vop_file add  constraint vop_pk primary key  (vop00,vop01,vop02,vop03,vop04,vop05,vop06) enable 
validate;
grant select on vop_file to public;
grant index on vop_file to public;
grant update on vop_file to public;
grant delete on vop_file to public;
grant insert on vop_file to public;