/*
================================================================================
档案代号:zaz_file
档案名称:Vprint 参数设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zaz_file
(
zaz01       varchar2(10) NOT NULL,   /*使用者                                 */
zaz02       varchar2(10) NOT NULL,   /*权限类别                               */
zaz03       varchar2(20) NOT NULL,   /*程式代码                               */
zaz04       varchar2(20) NOT NULL,   /*报表列印的样板                         */
zaz05       varchar2(80),            /*印表机名称                             */
zaz06       varchar2(1),             /*缩小列印选项                           */
zaz07       varchar2(1)              /*立即列印否                             */
);

create unique index zaz_pk on zaz_file (zaz01,zaz02,zaz03,zaz04);
alter table zaz_file add  constraint zaz_pk primary key  (zaz01,zaz02,zaz03,zaz04) enable validate;
grant select on zaz_file to public;
grant index on zaz_file to public;
grant update on zaz_file to public;
grant delete on zaz_file to public;
grant insert on zaz_file to public;