/*
================================================================================
档案代号:vaf_file
档案名称:aps仓库主档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vaf_file
(
vaf01       varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/
vaf02       varchar2(40),            /*仓库名称                               */
vaf03       number(5),               /*优先顺序                               */
vaf04       number(1),               /*存货不可移转                           */
vaf05       number(1)                /*主仓储                                 */
);

create unique index vaf_pk on vaf_file (vaf01);
alter table vaf_file add  constraint vaf_pk primary key  (vaf01) enable validate;
grant select on vaf_file to public;
grant index on vaf_file to public;
grant update on vaf_file to public;
grant delete on vaf_file to public;
grant insert on vaf_file to public;