/*
================================================================================
档案代号:voh_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table voh_file
(
voh00       varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/
voh01       varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/
voh02       varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/
voh03       varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/
voh04       number(1),               /*是否数量变更                           */
voh05       number(1),               /*是否日期变更                           */
voh06       number(1),               /*是否使用制令制程资料                   */
voh07       varchar2(1)              /*变更码                                 */
);

create unique index voh_pk on voh_file (voh00,voh01,voh02,voh03);
alter table voh_file add  constraint voh_pk primary key  (voh00,voh01,voh02,voh03) enable validate;
grant select on voh_file to public;
grant index on voh_file to public;
grant update on voh_file to public;
grant delete on voh_file to public;
grant insert on voh_file to public;