/*
================================================================================
档案代号:vag_file
档案名称:aps储位主档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vag_file
(
vag01       varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/
vag02       varchar2(10) DEFAULT '' NOT NULL, /*储位编号*/
vag03       varchar2(40),            /*储位名称                               */
vag04       number(5),               /*优先顺序                               */
vag05       number(1)                /*客供料                                 */
);

create unique index vag_pk on vag_file (vag01,vag02);
alter table vag_file add  constraint vag_pk primary key  (vag01,vag02) enable validate;
grant select on vag_file to public;
grant index on vag_file to public;
grant update on vag_file to public;
grant delete on vag_file to public;
grant insert on vag_file to public;