/*
================================================================================
档案代号:mea_file
档案名称:BOM 替代料资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table mea_file
(
mea01       number(5) NOT NULL,      /*流用代号                               */
mea02       varchar2(40) NOT NULL,   /*料件编号                               */
mea03       date,                    /*生效日期范围                           */
mea04       date,                    /*失效日期范围                           */
mea05       varchar2(20),            /*核准文号范围                           */
mea06       date                     /*核准日期范围                           */
);

create unique index mea_02 on mea_file (mea02);
create unique index mea_pk on mea_file (mea01,mea02);
alter table mea_file add  constraint mea_pk primary key  (mea01,mea02) enable validate;
grant select on mea_file to public;
grant index on mea_file to public;
grant update on mea_file to public;
grant delete on mea_file to public;
grant insert on mea_file to public;