/*
================================================================================
档案代号:gax_file
档案名称:4GL与PER关系档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gax_file
(
gax01       varchar2(20) NOT NULL,   /*程式代码                               */
gax02       varchar2(20) NOT NULL,   /*画面档代码                             */
gax03       varchar2(1),             /*是否实际存在                           */
gax04       varchar2(1),             /*是否为 help 使用                       */
gax05       varchar2(1) NOT NULL     /*客制码                                 */
);

create unique index gax_pk on gax_file (gax01,gax02,gax05);
alter table gax_file add  constraint gax_pk primary key  (gax01,gax02,gax05) enable validate;
grant select on gax_file to public;
grant index on gax_file to public;
grant update on gax_file to public;
grant delete on gax_file to public;
grant insert on gax_file to public;