View ocum.hapairview Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
objid bigint 19 Locally unique object identifier. ZAPIs: cf-get-iter.storage-failover-info
node1Id bigint 19 The objid of node1 in this ha_pair.
node2Id bigint 19 The objid of node2 in this ha_pair.
haPairName varchar 255  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `hapair`.`objid` AS `objid`,`hapair`.`node1Id` AS `node1Id`,`hapair`.`node2Id` AS `node2Id`,cast(concat(`node1`.`name`,'/',`node2`.`name`) as char(255) charset utf8mb4) AS `haPairName` from ((`netapp_model_view`.`node` `node1` join `netapp_model_view`.`node` `node2` on((`node1`.`objid` = `node2`.`partnerNodeId`))) join `netapp_model_view`.`ha_pair` `hapair` on(((`hapair`.`node1Id` = `node1`.`objid`) and (`hapair`.`node2Id` = `node1`.`partnerNodeId`))))