/* ================================================================================ 档案代号:apspfm 档案名称:APS 预测群组冲销 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table apspfm ( pid varchar2(40) NOT NULL, /*料号 */ mid varchar2(40) NOT NULL /*被冲销料号 */ ); create unique index apspfm_pk on apspfm (pid,mid); alter table apspfm add constraint apspfm_pk primary key (pid,mid) enable validate; grant select on apspfm to public; grant index on apspfm to public; grant update on apspfm to public; grant delete on apspfm to public; grant insert on apspfm to public; |