/*
================================================================================
档案代号:mpm_file
档案名称:MPS 模拟时距日期/供需日期归属档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table mpm_file
(
mpm_v       varchar2(10) NOT NULL,   /*模拟版本                               */
                                     /*空白表示为release为MPS计划时的时距     */
mpm_d       date NOT NULL,           /*时距日期                               */
mpm_act     date NOT NULL            /*供需日期                               */
);

create unique index mpm_pk on mpm_file (mpm_d,mpm_v,mpm_act);
alter table mpm_file add  constraint mpm_pk primary key  (mpm_d,mpm_v,mpm_act) enable validate;
grant select on mpm_file to public;
grant index on mpm_file to public;
grant update on mpm_file to public;
grant delete on mpm_file to public;
grant insert on mpm_file to public;