/*
================================================================================
档案代号:vmh_file
档案名称:aps供给法则维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vmh_file
(
vmh01       varchar2(60) DEFAULT '' NOT NULL, /*供给法则编号*/
vmh02       number(9) DEFAULT '0' NOT NULL, /*供给型态*/
vmh03       varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/
vmh04       varchar2(10) DEFAULT '' NOT NULL, /*储位编号*/
vmh05       number(5)                /*优先顺序                               */
);

create unique index vmh_pk on vmh_file (vmh01,vmh02,vmh03,vmh04);
alter table vmh_file add  constraint vmh_pk primary key  (vmh01,vmh02,vmh03,vmh04) enable validate;
grant select on vmh_file to public;
grant index on vmh_file to public;
grant update on vmh_file to public;
grant delete on vmh_file to public;
grant insert on vmh_file to public;