/*
================================================================================
档案代号:vzx_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vzx_file
(
vzx00       varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/
vzx01       varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/
vzx02       varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/
vzx03       number(1) DEFAULT '0' NOT NULL, /*是否可排程*/
vzx04       date DEFAULT sysdate NOT NULL /*修改日期*/
);

create unique index vzx_pk on vzx_file (vzx00,vzx01,vzx02,vzx03,vzx04);
alter table vzx_file add  constraint vzx_pk primary key  (vzx00,vzx01,vzx02,vzx03,vzx04) enable validate;
grant select on vzx_file to public;
grant index on vzx_file to public;
grant update on vzx_file to public;
grant delete on vzx_file to public;
grant insert on vzx_file to public;