/*
================================================================================
档案代号:zan_file
档案名称:定义查询计算(Sum)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zan_file
(
zan01       varchar2(80) NOT NULL,   /*查询单id                               */
zan02       number(5) NOT NULL,      /*序号                                   */
zan03       varchar2(1),             /*计算式-aggr                            */
zan04       varchar2(1),             /*依group栏位                            */
zan05       varchar2(80),            /*group栏位序号                          */
zan06       varchar2(255),           /*备注                                   */
zan07       varchar2(1),             /*显示方式                               */
zan08       varchar2(1) NOT NULL     /*客制码                                 */
);

create unique index zan_pk on zan_file (zan01,zan02,zan08);
alter table zan_file add  constraint zan_pk primary key  (zan01,zan02,zan08) enable validate;
grant select on zan_file to public;
grant index on zan_file to public;
grant update on zan_file to public;
grant delete on zan_file to public;
grant insert on zan_file to public;