/* ================================================================================ 档案代号:apsrgm 档案名称:APS 设备群组 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table apsrgm ( eqg_id varchar2(32) NOT NULL, /*设备群组编号 */ eq_id varchar2(32) NOT NULL /*设备编号 */ ); create unique index apsrgm_pk on apsrgm (eqg_id,eq_id); alter table apsrgm add constraint apsrgm_pk primary key (eqg_id,eq_id) enable validate; grant select on apsrgm to public; grant index on apsrgm to public; grant update on apsrgm to public; grant delete on apsrgm to public; grant insert on apsrgm to public; |