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