/*
================================================================================
档案代号:vzu_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vzu_file
(
vzu00       varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/
vzu01       varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/
vzu02       varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/
vzu03       number(5) DEFAULT '0' NOT NULL, /*程序编号*/
vzu04       varchar2(80),            /*程序名称                               */
vzu05       date,                    /*开始时间(日期)                         */
vzu06       date,                    /*结束时间(日期)                         */
vzu07       varchar2(1),             /*执行状态                               */
vzu08       varchar2(1)              /*APS整合类型                            */
);

create unique index vzu_pk on vzu_file (vzu00,vzu01,vzu02,vzu03);
alter table vzu_file add  constraint vzu_pk primary key  (vzu00,vzu01,vzu02,vzu03) enable validate;
grant select on vzu_file to public;
grant index on vzu_file to public;
grant update on vzu_file to public;
grant delete on vzu_file to public;
grant insert on vzu_file to public;