/*
================================================================================
档案代号:vzv_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vzv_file
(
vzv00       varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/
vzv01       varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/
vzv02       varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/
vzv03       date DEFAULT sysdate NOT NULL, /*讯息接收时间*/
vzv04       varchar2(30),            /*讯息代号                               */
vzv05       varchar2(80),            /*讯息说明                               */
vzv06       varchar2(1),             /*讯息状态                               */
vzv07       varchar2(1),             /*tiptop执行结果                         */
vzv08       varchar2(10)             /*操作人员代号                           */
);

create unique index vzv_pk on vzv_file (vzv00,vzv01,vzv02,vzv03);
alter table vzv_file add  constraint vzv_pk primary key  (vzv00,vzv01,vzv02,vzv03) enable validate;
grant select on vzv_file to public;
grant index on vzv_file to public;
grant update on vzv_file to public;
grant delete on vzv_file to public;
grant insert on vzv_file to public;