/*
================================================================================
档案代号:za_file
档案名称:报表标题档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table za_file
(
za01        varchar2(20) NOT NULL,   /*程式代号                               */
za02        number(5) NOT NULL,      /*序号                                   */
za03        varchar2(1) NOT NULL,    /*语言别                                 */
                                     /*语言别(0/1/2)                          */
                                     /*  0:中文                               */
                                     /*  1:英文                               */
                                     /*  2:简中                               */
za04        varchar2(255),           /*备注                                   */
za05        varchar2(80)             /*标题内容                               */
);

create unique index za_pk on za_file (za01,za02,za03);
alter table za_file add  constraint za_pk primary key  (za01,za02,za03) enable validate;
grant select on za_file to public;
grant index on za_file to public;
grant update on za_file to public;
grant delete on za_file to public;
grant insert on za_file to public;