/*
================================================================================
档案代号:zax_file
档案名称:CR认证记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zax_file
(
zax01       number(5) NOT NULL,      /*认证码                                 */
zax02       varchar2(10) NOT NULL,   /*使用者                                 */
zax03       varchar2(255) DEFAULT '1' NOT NULL, /*CR报表位置*/
                                     /*                                       */
                                     /*                                       */
                                     /*                                       */
                                     /*                                       */
                                     /*                                       */
                                     /*                                       */
zax04       varchar2(1000) DEFAULT '1' NOT NULL, /*CR报表SQL*/
zax05       varchar2(1000) DEFAULT '1' NOT NULL, /*CR报表参数1*/
zax06       varchar2(1000),          /*CR报表参数2                            */
zax07       varchar2(1000),          /*CR报表参数3                            */
zax08       varchar2(1) DEFAULT '1' NOT NULL, /*简繁转换*/
zax09       varchar2(255) DEFAULT '1' NOT NULL, /*LOGO位置*/
zax10       varchar2(255),           /*暂存档名                               */
zax11       varchar2(20),            /*使用者允许印表方式                     */
zax12       varchar2(1500),          /*子报表SQL1                             */
zax13       varchar2(1500),          /*子报表SQL2                             */
zax14       varchar2(1500),          /*子报表SQL3                             */
zax15       varchar2(1500),          /*子报表SQL4                             */
zax16       varchar2(1500),          /*子报表SQL5                             */
zax17       varchar2(1500),          /*子报表SQL                              */
zax18       varchar2(1500),          /*子报表SQL                              */
zax19       varchar2(1500),          /*子报表SQL                              */
zax20       varchar2(1500),          /*子报表SQL                              */
zax21       varchar2(1500),          /*子报表SQL                              */
zax22       varchar2(1500),          /*子报表SQL                              */
zax23       varchar2(1500),          /*子报表SQL                              */
zax24       varchar2(1500),          /*子报表SQL                              */
zax25       varchar2(1500),          /*子报表SQL                              */
zax26       varchar2(1500),          /*子报表SQL                              */
zax27       varchar2(1),             /*no use                                 */
zax28       varchar2(1)              /*no use                                 */
);

create unique index zax_pk on zax_file (zax01);
alter table zax_file add  constraint zax_pk primary key  (zax01) enable validate;
grant select on zax_file to public;
grant index on zax_file to public;
grant update on zax_file to public;
grant delete on zax_file to public;
grant insert on zax_file to public;