/*
================================================================================
档案代号:aps_pfm
档案名称:APS 预测群组冲销维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_pfm
(
pid         varchar2(40) NOT NULL,   /*料号                                   */
mid         varchar2(40) NOT NULL    /*被冲销料号                             */
);

create unique index aps_pfm_pk on aps_pfm (pid,mid);
alter table aps_pfm add  constraint aps_pfm_pk primary key  (pid,mid) enable validate;
grant select on aps_pfm to public;
grant index on aps_pfm to public;
grant update on aps_pfm to public;
grant delete on aps_pfm to public;
grant insert on aps_pfm to public;