/*
================================================================================
档案代号:apsarm
档案名称:APS 品项分配法则
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table apsarm
(
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 apsarm_pk on apsarm (pid,rid,compt,sply_rid);
alter table apsarm add  constraint apsarm_pk primary key  (pid,rid,compt,sply_rid) enable validate;
grant select on apsarm to public;
grant index on apsarm to public;
grant update on apsarm to public;
grant delete on apsarm to public;
grant insert on apsarm to public;