/*
================================================================================
档案代号:zzw_file
档案名称:报表输出格式参数设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zzw_file
(
zzw01       varchar2(20) NOT NULL,   /*程式代号                               */
                                     /*程式代号, (program code)               */
                                     /* Ex:pka0203 , pkb0218                  */
zzw02       varchar2(255),           /*报表栏位参数                           */
zzw03       varchar2(1),             /*是否直接产生图表                       */
zzw04       varchar2(2),             /*图表X轴资料来源栏位位置                */
zzw05       varchar2(2),             /*图表Y轴资料来源栏位位置                */
zzw06       varchar2(2),             /*图表Z轴资料来源栏位位置                */
zzw07       varchar2(3),             /*图表预设图形代号                       */
zzw08       varchar2(2)              /*图表区预设字形大小                     */
);

create unique index zzw_pk on zzw_file (zzw01);
alter table zzw_file add  constraint zzw_pk primary key  (zzw01) enable validate;
grant select on zzw_file to public;
grant index on zzw_file to public;
grant update on zzw_file to public;
grant delete on zzw_file to public;
grant insert on zzw_file to public;