/*
================================================================================
档案代号:zg_file
档案名称:统计图型单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zg_file
(
zg01        varchar2(5) NOT NULL,    /*图形代号                               */
zg02        varchar2(1),             /*图形类别                               */
                                     /*1.Bar chart 2.Line chart 3.Pie chart   */
zg03        number(5),               /*Group no                               */
                                     /*Ex: 12 (月)                            */
zg04        number(5),               /*Item no                                */
                                     /*每一 Group 内的 Item 数目              */
                                     /*Ex: 3 (业务员)                         */
zg05        varchar2(80),            /*图形抬头                               */
                                     /*TITLE                                  */
zg06        varchar2(80),            /*图形次抬头                             */
                                     /*SUBTITLE                               */
zg07        varchar2(80),            /*纵轴标题                               */
                                     /*X-WAY                                  */
zg08        varchar2(80),            /*横轴标题                               */
                                     /*Y-WAY                                  */
zg09        varchar2(80),            /*明细标题                               */
                                     /*LABEL                                  */
zg10        varchar2(70),            /*SQL-1                                  */
zg11        varchar2(70),            /*SQL-2                                  */
zg12        varchar2(70),            /*SQL-3                                  */
zguser      varchar2(10),
zgdate      date
);

create unique index zg_pk on zg_file (zg01);
alter table zg_file add  constraint zg_pk primary key  (zg01) enable validate;
grant select on zg_file to public;
grant index on zg_file to public;
grant update on zg_file to public;
grant delete on zg_file to public;
grant insert on zg_file to public;