/* ================================================================================ 档案代号:msk_file 档案名称:MRP 模拟时距日期档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table msk_file ( msk_v varchar2(10) NOT NULL, /*模拟版本 */ msk_d date NOT NULL /*时距日期 */ ); create unique index msk_pk on msk_file (msk_d,msk_v); alter table msk_file add constraint msk_pk primary key (msk_d,msk_v) enable validate; grant select on msk_file to public; grant index on msk_file to public; grant update on msk_file to public; grant delete on msk_file to public; grant insert on msk_file to public; |