View netapp_model_view.vserver_peer 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
originid bigint 19
uuid varchar 255 Globally unique ID of the local vserver in the relationship.
resourceKey varchar 255
clusterId bigint 19 Foreign key to the cluster table.
vServerId bigint 19 Foreign key to the vserver table.
peerClusterId bigint 19  √  null The peer cluster ID
peerClusterName varchar 255  √  null The peer cluster name
peerVServerName varchar 255  √  null The name of the peer Vserver in the relationship.
peerVServerUUID varchar 255  √  null The UUID of the peer Vserver in the relationship.
peerVServerId bigint 19  √  null Foreign key to the vserver table.
peerState enum 12  √  null The state of the vserver peer relationship.
peerStateRaw varchar 255  √  null The state of the vserver peer relationship.
applications varchar 255  √  null The applications which can make use of the peering relationship. The possible application values are: snapmirror, file_copy and lun_copy.
createtime bigint 19
updatetime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`vserver_peer`.`objid` AS `objid`,`netapp_model`.`vserver_peer`.`originid` AS `originid`,`netapp_model`.`vserver_peer`.`uuid` AS `uuid`,`netapp_model`.`vserver_peer`.`resourceKey` AS `resourceKey`,`netapp_model`.`vserver_peer`.`clusterId` AS `clusterId`,`netapp_model`.`vserver_peer`.`vServerId` AS `vServerId`,`netapp_model`.`vserver_peer`.`peerClusterId` AS `peerClusterId`,`netapp_model`.`vserver_peer`.`peerClusterName` AS `peerClusterName`,`netapp_model`.`vserver_peer`.`peerVServerName` AS `peerVServerName`,`netapp_model`.`vserver_peer`.`peerVServerUUID` AS `peerVServerUUID`,`netapp_model`.`vserver_peer`.`peerVServerId` AS `peerVServerId`,`netapp_model`.`vserver_peer`.`peerState` AS `peerState`,`netapp_model`.`vserver_peer`.`peerStateRaw` AS `peerStateRaw`,`netapp_model`.`vserver_peer`.`applications` AS `applications`,`netapp_model`.`vserver_peer`.`createtime` AS `createtime`,`netapp_model`.`vserver_peer`.`updatetime` AS `updatetime` from `netapp_model`.`vserver_peer` where (`netapp_model`.`vserver_peer`.`objState` = 'LIVE')