/* ================================================================================ 档案代号:aps_imd 档案名称:APS 仓库维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aps_imd ( wh_id varchar2(32) NOT NULL, /*库房编号 */ immove number(4), /*仓储存货是否“不可”移转到 */ is_main number(4) /*仓储是否为主仓储(0:否 1:是) */ ); create unique index aps_imd_pk on aps_imd (wh_id); alter table aps_imd add constraint aps_imd_pk primary key (wh_id) enable validate; grant select on aps_imd to public; grant index on aps_imd to public; grant update on aps_imd to public; grant delete on aps_imd to public; grant insert on aps_imd to public; |