/*
================================================================================
档案代号:vmp_file
档案名称:aps资源群组维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vmp_file
(
vmp01       varchar2(60) DEFAULT '' NOT NULL, /*资源群组编号*/
vmp02       varchar2(10) DEFAULT '' NOT NULL /*资源编号*/
);

create unique index vmp_pk on vmp_file (vmp01,vmp02);
alter table vmp_file add  constraint vmp_pk primary key  (vmp01,vmp02) enable validate;
grant select on vmp_file to public;
grant index on vmp_file to public;
grant update on vmp_file to public;
grant delete on vmp_file to public;
grant insert on vmp_file to public;