/* ================================================================================ 档案代号:aps_ime 档案名称:APS 储位维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aps_ime ( wh_id varchar2(32) NOT NULL, /*库房编号 */ stk_loc varchar2(32) NOT NULL, /*库房储位 */ is_cnsn number(4) /*是否为客供料(0:不是 1:是) */ ); create unique index aps_ime_pk on aps_ime (wh_id,stk_loc); alter table aps_ime add constraint aps_ime_pk primary key (wh_id,stk_loc) enable validate; grant select on aps_ime to public; grant index on aps_ime to public; grant update on aps_ime to public; grant delete on aps_ime to public; grant insert on aps_ime to public; |