/*
================================================================================
档案代号:aps_arm
档案名称:APS 品项分配法则维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aps_arm
(
pid         varchar2(40) NOT NULL,   /*料号                                   */
rid         varchar2(32) NOT NULL,   /*供给法则编号                           */
compt       varchar2(40) NOT NULL,   /*为part_id 本身或其下阶品项之           */
sply_rid    varchar2(32) NOT NULL    /*供给法则编号                           */
);

create unique index aps_arm_pk on aps_arm (pid,rid,compt,sply_rid);
alter table aps_arm add  constraint aps_arm_pk primary key  (pid,rid,compt,sply_rid) enable validate;
grant select on aps_arm to public;
grant index on aps_arm to public;
grant update on aps_arm to public;
grant delete on aps_arm to public;
grant insert on aps_arm to public;