/*
================================================================================
档案代号:zaa_file
档案名称:报表相关格式设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zaa_file
(
zaa01       varchar2(20) NOT NULL,   /*程式代号                               */
zaa02       number(5) NOT NULL,      /*序号                                   */
zaa03       varchar2(1) NOT NULL,    /*语言别                                 */
zaa04       varchar2(10) NOT NULL,   /*使用者                                 */
zaa05       number(5),               /*定位点                                 */
zaa06       varchar2(1),             /*隐藏是否                               */
zaa07       number(5),               /*栏位顺序                               */
zaa08       varchar2(1500),          /*栏位内容                               */
zaa09       varchar2(1),             /*类别                                   */
zaa10       varchar2(1) NOT NULL,    /*客制否                                 */
zaa11       varchar2(20) NOT NULL,   /*报表列印的样板                         */
zaa12       number(5),               /*报表列印的行数                         */
zaa13       varchar2(1),             /*栏位调换否                             */
zaa14       varchar2(1),             /*栏位属性                               */
zaa15       number(5),               /*行序                                   */
zaa16       varchar2(1),             /*列印备注(签核)否                       */
zaa17       varchar2(10) NOT NULL,   /*权限类别                               */
zaa18       number(5),               /*单行顺序                               */
zaa19       number(5),               /*报表左边界                             */
zaa20       number(5),               /*报表上边界                             */
zaa21       number(5),               /*报表下边界                             */
zaa22       varchar2(1)              /*No Use                                 */
);

create unique index zaa_pk on zaa_file (zaa01,zaa02,zaa03,zaa04,zaa10,zaa11,zaa17);
alter table zaa_file add  constraint zaa_pk primary key  (zaa01,zaa02,zaa03,zaa04,zaa10,zaa11,zaa17) enable 
validate;
grant select on zaa_file to public;
grant index on zaa_file to public;
grant update on zaa_file to public;
grant delete on zaa_file to public;
grant insert on zaa_file to public;