/*
================================================================================
档案代号:bmi_file
档案名称:机种代号维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bmi_file
(
bmi01       varchar2(5) NOT NULL,    /*机种代码                               */
bmi02       varchar2(80),            /*机种说明                               */
bmiacti     varchar2(1),             /*资料有效码                             */
bmiuser     varchar2(10),            /*资料所有者                             */
bmigrup     varchar2(10),            /*资料所有部门                           */
bmimodu     varchar2(10),            /*资料修改者                             */
bmidate     date                     /*最近修改日                             */
);

create unique index bmi_pk on bmi_file (bmi01);
alter table bmi_file add  constraint bmi_pk primary key  (bmi01) enable validate;
grant select on bmi_file to public;
grant index on bmi_file to public;
grant update on bmi_file to public;
grant delete on bmi_file to public;
grant insert on bmi_file to public;