/*
================================================================================
档案代号:vog_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vog_file
(
vog00       varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/
vog01       varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/
vog02       varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/
vog03       varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/
vog04       varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/
vog05       varchar2(60) DEFAULT '' NOT NULL, /*制程序号*/
vog06       varchar2(40) DEFAULT '' NOT NULL, /*元件料号*/
vog07       date,                    /*需求时点                               */
vog08       varchar2(6)              /*作业编号                               */
);

create unique index vog_pk on vog_file (vog00,vog01,vog02,vog03,vog04,vog05,vog06);
alter table vog_file add  constraint vog_pk primary key  (vog00,vog01,vog02,vog03,vog04,vog05,vog06) enable 
validate;
grant select on vog_file to public;
grant index on vog_file to public;
grant update on vog_file to public;
grant delete on vog_file to public;
grant insert on vog_file to public;