/*
================================================================================
档案代号:zap_file
档案名称:定义查询 output
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zap_file
(
zap01       varchar2(80) NOT NULL,   /*查询单id                               */
zap02       number(5),               /*报表列印的行数                         */
zap03       number(5),               /*报表上边界                             */
zap04       number(5),               /*报表左边界                             */
zap05       number(5),               /*报表下边界                             */
zap06       number(10),              /*报表最大查询笔数                       */
zap07       varchar2(1) NOT NULL     /*客制码                                 */
);

create unique index zap_pk on zap_file (zap01,zap07);
alter table zap_file add  constraint zap_pk primary key  (zap01,zap07) enable validate;
grant select on zap_file to public;
grant index on zap_file to public;
grant update on zap_file to public;
grant delete on zap_file to public;
grant insert on zap_file to public;