/* ================================================================================ 档案代号:apssrm 档案名称:APS 供给法则 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table apssrm ( 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 apssrm_pk on apssrm (rid,sply_typ,wh_id,stk_loc); alter table apssrm add constraint apssrm_pk primary key (rid,sply_typ,wh_id,stk_loc) enable validate; grant select on apssrm to public; grant index on apssrm to public; grant update on apssrm to public; grant delete on apssrm to public; grant insert on apssrm to public; |