/*
================================================================================
档案代号:zv_file
档案名称:程式使用者固定列印方式资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zv_file
(
zv01        varchar2(20) NOT NULL,   /*程式代号                               */
                                     /*程式代号, (program code)               */
zv02        varchar2(10) NOT NULL,   /*使用者代号                             */
zv03        varchar2(1),             /*固定列印方式                           */
zv04        varchar2(1),             /*Local Print Control Code               */
zvacti      varchar2(1),             /*有效否                                 */
zv05        varchar2(10) DEFAULT '' NOT NULL, /*权限类别*/
zv06        varchar2(20) DEFAULT '' NOT NULL, /*报表列印的样板*/
zv07        varchar2(80),            /*印表机名称                             */
zv08        varchar2(1)              /*立即列印否                             */
);

create unique index zv_pk on zv_file (zv01,zv02,zv05,zv06);
alter table zv_file add  constraint zv_pk primary key  (zv01,zv02,zv05,zv06) enable validate;
grant select on zv_file to public;
grant index on zv_file to public;
grant update on zv_file to public;
grant delete on zv_file to public;
grant insert on zv_file to public;