/*
================================================================================
档案代号:gaz_file
档案名称:程式名称多语言记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gaz_file
(
gaz01       varchar2(20) NOT NULL,   /*程式代码                               */
                                     /*program code                           */
gaz02       varchar2(1) NOT NULL,    /*语言别                                 */
gaz03       varchar2(120),           /*程式名称                               */
gaz04       varchar2(4000),          /*作业目的                               */
gaz05       varchar2(1) NOT NULL,    /*客制码                                 */
gazuser     varchar2(10),            /*Create User                            */
gazgrup     varchar2(10),            /*Modify Group                           */
gazmodu     varchar2(10),            /*Modify User                            */
gazdate     date,                    /*Modify Date                            */
gaz06       varchar2(255)            /*报表列印抬头                           */
);

create unique index gaz_pk on gaz_file (gaz01,gaz02,gaz05);
alter table gaz_file add  constraint gaz_pk primary key  (gaz01,gaz02,gaz05) enable validate;
grant select on gaz_file to public;
grant index on gaz_file to public;
grant update on gaz_file to public;
grant delete on gaz_file to public;
grant insert on gaz_file to public;