/*
================================================================================
档案代号:vom_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vom_file
(
vom00       varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/
vom01       varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/
vom02       varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/
vom03       varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/
vom04       varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/
vom05       varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/
vom06       varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/
vom07       varchar2(10) DEFAULT '' NOT NULL, /*资源编号*/
vom08       number(1),               /*锁定码                                 */
vom09       date,                    /*开始时间(日期)                         */
vom10       date,                    /*结束时间(日期)                         */
vom11       number(1),               /*排程                                   */
vom12       number(1)                /*平行机台任务                           */
);

create unique index vom_pk on vom_file (vom00,vom01,vom02,vom03,vom04,vom05,vom06,vom07);
alter table vom_file add  constraint vom_pk primary key  (vom00,vom01,vom02,vom03,vom04,vom05,vom06,vom07) 
enable validate;
grant select on vom_file to public;
grant index on vom_file to public;
grant update on vom_file to public;
grant delete on vom_file to public;
grant insert on vom_file to public;