/*
================================================================================
档案代号:voc_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table voc_file
(
voc00       varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/
voc01       varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/
voc02       varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/
voc03       varchar2(10) DEFAULT '' NOT NULL, /*采购令编号*/
voc04       number(1),               /*是否数量变更                           */
voc05       number(1)                /*是否日期变更                           */
);

create unique index voc_pk on voc_file (voc00,voc01,voc02,voc03);
alter table voc_file add  constraint voc_pk primary key  (voc00,voc01,voc02,voc03) enable validate;
grant select on voc_file to public;
grant index on voc_file to public;
grant update on voc_file to public;
grant delete on voc_file to public;
grant insert on voc_file to public;