/*
================================================================================
档案代号:fge_file
档案名称:不良原因代码说明资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fge_file
(
fge01       varchar2(4) NOT NULL,    /*不良原因代码                           */
fge02       varchar2(1),             /*No Use                                 */
fge03       varchar2(80),            /*说明内容                               */
fge04       varchar2(1),             /*No Use                                 */
fgeacti     varchar2(1),             /*资料有效码                             */
fgeuser     varchar2(10),            /*原始资料建立者                         */
fgegrup     varchar2(10),            /*使用者部门                             */
fgemodu     varchar2(10),            /*最后修改资料者                         */
fgedate     date                     /*最后修改日期                           */
);

create unique index fge_pk on fge_file (fge01);
alter table fge_file add  constraint fge_pk primary key  (fge01) enable validate;
grant select on fge_file to public;
grant index on fge_file to public;
grant update on fge_file to public;
grant delete on fge_file to public;
grant insert on fge_file to public;