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