/* ================================================================================ 档案代号:gbr_file 档案名称:自订栏位检查维护档 档案目的:自订栏位检查设定 上游档案: 下游档案: ============.========================.========================================== */ create table gbr_file ( gbr01 varchar2(20), /*画面代码 */ gbr02 varchar2(20), /*栏位代码 */ gbr03 varchar2(1), /*客制码 */ gbr04 varchar2(50), /*对应检查的表格栏位 */ gbr05 varchar2(1), /*是否要设定范围 */ gbr06 varchar2(15), /*范围起始 */ gbr07 varchar2(15), /*范围结束 */ gbr08 varchar2(20), /*动态开窗查询 */ gbr09 varchar2(1), /*No Use */ gbr10 varchar2(1), /*No Use */ gbr11 varchar2(1) /*No Use */ ); grant select on gbr_file to public; grant index on gbr_file to public; grant update on gbr_file to public; grant delete on gbr_file to public; grant insert on gbr_file to public; |