/*
================================================================================
档案代号:fgd_file
档案名称:校定项目基本资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fgd_file
(
fgd01       varchar2(6) NOT NULL,    /*校定项目                               */
fgd02       varchar2(80),            /*校定项目名称                           */
fgdacti     varchar2(1),             /*资料有效码                             */
fgduser     varchar2(10),            /*资料所有者                             */
fgdgrup     varchar2(10),            /*资料所有群                             */
fgdmodu     varchar2(10),            /*资料更改者                             */
fgddate     date                     /*最近修改日                             */
);

create unique index fgd_pk on fgd_file (fgd01);
alter table fgd_file add  constraint fgd_pk primary key  (fgd01) enable validate;
grant select on fgd_file to public;
grant index on fgd_file to public;
grant update on fgd_file to public;
grant delete on fgd_file to public;
grant insert on fgd_file to public;