/* ================================================================================ 档案代号: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; |