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