/* ================================================================================ 档案代号: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; |