/*
================================================================================
档案代号:von_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table von_file
(
von00       varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/
von01       varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/
von02       varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/
von03       varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/
von04       varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/
von05       varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/
von06       varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/
von07       varchar2(10) DEFAULT '' NOT NULL, /*资源编号*/
von08       number(15,3),            /*未完成量                               */
von09       number(1)                /*排程                                   */
);

create unique index von_pk on von_file (von00,von01,von02,von03,von04,von05,von06,von07);
alter table von_file add  constraint von_pk primary key  (von00,von01,von02,von03,von04,von05,von06,von07) 
enable validate;
grant select on von_file to public;
grant index on von_file to public;
grant update on von_file to public;
grant delete on von_file to public;
grant insert on von_file to public;