/* ================================================================================ 档案代号:gbm_file 档案名称:查询条件纪录单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gbm_file ( gbm01 number(10) NOT NULL, /*QBE序号 */ gbm02 varchar2(10), /*使用者 */ gbm03 varchar2(20), /*程式代号 */ gbm04 varchar2(20), /*查询条件代码 */ gbm05 varchar2(1500), /*说明 */ gbm06 varchar2(1), /*预设QBE */ gbm07 varchar2(1), /*查询时是否直接带入 */ gbm08 varchar2(1), /*是否分享 */ gbm09 varchar2(2000) /*No Use */ ); create unique index gbm_02 on gbm_file (gbm02,gbm03,gbm04); create unique index gbm_pk on gbm_file (gbm01); alter table gbm_file add constraint gbm_pk primary key (gbm01) enable validate; grant select on gbm_file to public; grant index on gbm_file to public; grant update on gbm_file to public; grant delete on gbm_file to public; grant insert on gbm_file to public; |