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