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