/*
================================================================================
档案代号:geo_file
档案名称:地区资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table geo_file
(
geo01       varchar2(10) NOT NULL,   /*地区编号                               */
geo02       varchar2(80),            /*地区名称                               */
geo03       varchar2(10),            /*隶属国别                               */
geoacti     varchar2(1),             /*资料有效码                             */
geouser     varchar2(10),            /*资料所有者                             */
geogrup     varchar2(10),            /*资料所有部门                           */
geomodu     varchar2(10),            /*资料修改者                             */
geodate     date                     /*最近修改日                             */
);

create unique index geo_pk on geo_file (geo01);
alter table geo_file add  constraint geo_pk primary key  (geo01) enable validate;
grant select on geo_file to public;
grant index on geo_file to public;
grant update on geo_file to public;
grant delete on geo_file to public;
grant insert on geo_file to public;