/* ================================================================================ 档案代号:vme_file 档案名称:aps资源群组维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vme_file ( vme01 varchar2(60) DEFAULT '' NOT NULL, /*资源群组编号*/ vme02 varchar2(10) DEFAULT '' NOT NULL /*资源编号*/ ); create unique index vme_pk on vme_file (vme01,vme02); alter table vme_file add constraint vme_pk primary key (vme01,vme02) enable validate; grant select on vme_file to public; grant index on vme_file to public; grant update on vme_file to public; grant delete on vme_file to public; grant insert on vme_file to public; |