/*
================================================================================
档案代号:gap_file
档案名称:程式与ACTION关系档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gap_file
(
gap01       varchar2(20) NOT NULL,   /*程式代码                               */
gap02       varchar2(80) NOT NULL,   /*Action 代码                            */
gap03       varchar2(1),             /*自设注记                               */
gap04       varchar2(1),             /*单身属性注记                           */
gap05       varchar2(1),             /*是否置入topmenu (4tm)                  */
gap06       varchar2(1),             /*Action 是否被抓取的设定旗标            */
gap07       varchar2(1),             /*No Use                                 */
gap08       varchar2(25)             /*快速键                                 */
);

create unique index gap_pk on gap_file (gap01,gap02);
alter table gap_file add  constraint gap_pk primary key  (gap01,gap02) enable validate;
grant select on gap_file to public;
grant index on gap_file to public;
grant update on gap_file to public;
grant delete on gap_file to public;
grant insert on gap_file to public;