/*
================================================================================
档案代号:zae_file
档案名称:报表连查sql设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zae_file
(
zae01       varchar2(10) NOT NULL,   /*报表连查sql 代号                       */
zae02       varchar2(80),            /*代号说明                               */
zae03       varchar2(255),           /*sql内容                                */
zae04       number(5) NOT NULL,      /*序号                                   */
zae05       varchar2(1) NOT NULL,    /*语言别                                 */
zae06       varchar2(20),            /*栏位代号                               */
zae07       varchar2(80),            /*栏位说明                               */
zae08       number(5) NOT NULL,      /*报表下阶联查序号                       */
zae09       varchar2(1),             /*报表下阶联查类型 1:程式代号            */
zae10       varchar2(20)             /*报表下阶连查内容                       */
);

create unique index zae_pk on zae_file (zae01,zae04,zae05,zae08);
alter table zae_file add  constraint zae_pk primary key  (zae01,zae04,zae05,zae08) enable validate;
grant select on zae_file to public;
grant index on zae_file to public;
grant update on zae_file to public;
grant delete on zae_file to public;
grant insert on zae_file to public;