/*
================================================================================
档案代号:vmt_file
档案名称:aps 预测群组冲销维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vmt_file
(
vmt01       varchar2(40) DEFAULT '' NOT NULL, /*主冲销料号*/
vmt02       varchar2(40) DEFAULT '' NOT NULL /*被冲销料号*/
);

create unique index vmt_pk on vmt_file (vmt01,vmt02);
alter table vmt_file add  constraint vmt_pk primary key  (vmt01,vmt02) enable validate;
grant select on vmt_file to public;
grant index on vmt_file to public;
grant update on vmt_file to public;
grant delete on vmt_file to public;
grant insert on vmt_file to public;