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