/*
================================================================================
档案代号:mmi_file
档案名称:工作性质档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table mmi_file
(
mmi01       varchar2(2) NOT NULL,    /*工作性质码                             */
mmi02       varchar2(80),            /*工作性质说明                           */
mmi03       varchar2(1),             /*区别                                   */
                                     /*区别 1.工作性质 2.需求类别             */
mmiacti     varchar2(1),             /*资料有效码                             */
mmiuser     varchar2(10),            /*资料所有者                             */
                                     /*系统维护                               */
mmigrup     varchar2(10),            /*资料所有群                             */
                                     /*系统维护                               */
mmimodu     varchar2(10),            /*资料更改者                             */
                                     /*系统维护                               */
mmidate     date                     /*最近修改日                             */
                                     /*系统维护                               */
);

create unique index mmi_pk on mmi_file (mmi01);
alter table mmi_file add  constraint mmi_pk primary key  (mmi01) enable validate;
grant select on mmi_file to public;
grant index on mmi_file to public;
grant update on mmi_file to public;
grant delete on mmi_file to public;
grant insert on mmi_file to public;