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

create unique index mpk_pk on mpk_file (mpk_d,mpk_v);
alter table mpk_file add  constraint mpk_pk primary key  (mpk_d,mpk_v) enable validate;
grant select on mpk_file to public;
grant index on mpk_file to public;
grant update on mpk_file to public;
grant delete on mpk_file to public;
grant insert on mpk_file to public;