/*
================================================================================
档案代号:apswhm
档案名称:APS 仓库主档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table apswhm
(
wh_id       varchar2(32) NOT NULL,   /*库房编号                               */
wh_name     varchar2(32),            /*仓库名称                               */
priority    number(10),              /*优先顺序                               */
immove      number(4),               /*仓储存货是否“不可”移转到             */
is_main     number(4)                /*仓储是否为主仓储(0:否 1:是)            */
);

create unique index apswhm_pk on apswhm (wh_id);
alter table apswhm add  constraint apswhm_pk primary key  (wh_id) enable validate;
grant select on apswhm to public;
grant index on apswhm to public;
grant update on apswhm to public;
grant delete on apswhm to public;
grant insert on apswhm to public;