/*
================================================================================
档案代号:gfe_file
档案名称:单位档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gfe_file
(
gfe01       varchar2(4) NOT NULL,    /*单位                                   */
gfe02       varchar2(80),            /*说明                                   */
gfe03       number(5),               /*小数位数                               */
gfeacti     varchar2(1),             /*资料有效码                             */
gfeuser     varchar2(10),            /*资料所有者                             */
gfegrup     varchar2(10),            /*资料所有部门                           */
gfemodu     varchar2(10),            /*资料修改者                             */
gfedate     date                     /*最近修改日                             */
);

create unique index gfe_pk on gfe_file (gfe01);
alter table gfe_file add  constraint gfe_pk primary key  (gfe01) enable validate;
grant select on gfe_file to public;
grant index on gfe_file to public;
grant update on gfe_file to public;
grant delete on gfe_file to public;
grant insert on gfe_file to public;