/*
================================================================================
档案代号:gbf_file
档案名称:程式作业特色维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gbf_file
(
gbf01       varchar2(20) NOT NULL,   /*程式代码                               */
                                     /*                                       */
gbf02       varchar2(1) NOT NULL,    /*语言别                                 */
gbf03       number(5) NOT NULL,      /*主项次                                 */
gbf04       number(5) NOT NULL,      /*次项次                                 */
gbf05       varchar2(500),           /*程式特点                               */
gbf06       varchar2(1) NOT NULL,    /*No Use                                 */
gbf07       varchar2(1),             /*No Use                                 */
gbfuser     varchar2(10),            /*资料所有者                             */
gbfgrup     varchar2(10),            /*资料建立部门                           */
gbfmodu     varchar2(10),            /*资料更改者                             */
gbfdate     date                     /*资料建立日期                           */
);

create unique index gbf_pk on gbf_file (gbf01,gbf02,gbf03,gbf04,gbf06);
alter table gbf_file add  constraint gbf_pk primary key  (gbf01,gbf02,gbf03,gbf04,gbf06) enable validate;
grant select on gbf_file to public;
grant index on gbf_file to public;
grant update on gbf_file to public;
grant delete on gbf_file to public;
grant insert on gbf_file to public;