/* ================================================================================ 档案代号:aps_srm 档案名称:APS 供给法则维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aps_srm ( rid varchar2(32) NOT NULL, /*供给法则编号 */ sply_typ number(4) NOT NULL, /*供给型态 */ wh_id varchar2(32) NOT NULL, /*库房编号 */ stk_loc varchar2(32) NOT NULL, /*库房储位 */ priority number(10) /*优先顺序 */ ); create unique index aps_srm_pk on aps_srm (rid,sply_typ,wh_id,stk_loc); alter table aps_srm add constraint aps_srm_pk primary key (rid,sply_typ,wh_id,stk_loc) enable validate; grant select on aps_srm to public; grant index on aps_srm to public; grant update on aps_srm to public; grant delete on aps_srm to public; grant insert on aps_srm to public; |