View netapp_model_view.cluster_peer_full 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 peer cluster.
resourceKey varchar 255
clusterId bigint 19
activeAddresses text 65535  √  null The active IP addresses of the peer cluster. Available in the local cluster from a cache.
addressFamily enum 10  √  null The address family of the peer cluster connection.
addressFamilyRaw varchar 255  √  null The address family of the peer cluster connection.
authStatusAdmin varchar 255  √  null The desired status for the authentication of the peer relationship, according to this cluster. Available in the local cluster.
authStatusOperational enum 17  √  null The actual status of the authentication interaction with the peer cluster. Available in the local cluster from a cache.
authStatusOperationalRaw varchar 255  √  null The actual status of the authentication interaction with the peer cluster. Available in the local cluster from a cache.
availability enum 12  √  null The status of the peer cluster connection. Available in the local cluster from a cache.
availabilityRaw varchar 255  √  null The status of the peer cluster connection. Available in the local cluster from a cache.
remoteClusterName varchar 255  √  null The name of the peer cluster. Available in the local cluster.
remoteClusterUUID varchar 255  √  null The UUID of the peer cluster. Available in the local cluster.
remoteClusterId bigint 19  √  null Foreign key to the cluster table. Available if the remote cluster is registered
networkIpSpaceId bigint 19  √  null IPspace in which the LIFs for this relationship are to be found. Foreign key to the network_ip_space table
isClusterHealthy bit 0  √  null The status of peer cluster health. Available in the local cluster from a cache.
peerAddresses text 65535  √  null The remote IP address or host name of the peer cluster. Available in the local cluster.
remoteClusterNodes text 65535  √  null The list of all the nodes in the peer cluster. Available in the local cluster.
serialNumber varchar 255  √  null This is an assigned serial number of peer cluster. It is assigned at the time of cluster create.
unreachableLocalNodes text 65535  √  null List of local nodes not contactable from the node on which the command is executed. Available in the local cluster from a cache.
encrypt enum 11  √  null type of the encrypt
encryptRaw varchar 64  √  null raw type of the encrypt
createtime bigint 19
updatetime bigint 19
objState enum 5  √  null

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`cluster_peer`.`objid` AS `objid`,`netapp_model`.`cluster_peer`.`originid` AS `originid`,`netapp_model`.`cluster_peer`.`uuid` AS `uuid`,`netapp_model`.`cluster_peer`.`resourceKey` AS `resourceKey`,`netapp_model`.`cluster_peer`.`clusterId` AS `clusterId`,`netapp_model`.`cluster_peer`.`activeAddresses` AS `activeAddresses`,`netapp_model`.`cluster_peer`.`addressFamily` AS `addressFamily`,`netapp_model`.`cluster_peer`.`addressFamilyRaw` AS `addressFamilyRaw`,`netapp_model`.`cluster_peer`.`authStatusAdmin` AS `authStatusAdmin`,`netapp_model`.`cluster_peer`.`authStatusOperational` AS `authStatusOperational`,`netapp_model`.`cluster_peer`.`authStatusOperationalRaw` AS `authStatusOperationalRaw`,`netapp_model`.`cluster_peer`.`availability` AS `availability`,`netapp_model`.`cluster_peer`.`availabilityRaw` AS `availabilityRaw`,`netapp_model`.`cluster_peer`.`remoteClusterName` AS `remoteClusterName`,`netapp_model`.`cluster_peer`.`remoteClusterUUID` AS `remoteClusterUUID`,`netapp_model`.`cluster_peer`.`remoteClusterId` AS `remoteClusterId`,`netapp_model`.`cluster_peer`.`networkIpSpaceId` AS `networkIpSpaceId`,`netapp_model`.`cluster_peer`.`isClusterHealthy` AS `isClusterHealthy`,`netapp_model`.`cluster_peer`.`peerAddresses` AS `peerAddresses`,`netapp_model`.`cluster_peer`.`remoteClusterNodes` AS `remoteClusterNodes`,`netapp_model`.`cluster_peer`.`serialNumber` AS `serialNumber`,`netapp_model`.`cluster_peer`.`unreachableLocalNodes` AS `unreachableLocalNodes`,`netapp_model`.`cluster_peer`.`encrypt` AS `encrypt`,`netapp_model`.`cluster_peer`.`encryptRaw` AS `encryptRaw`,`netapp_model`.`cluster_peer`.`createtime` AS `createtime`,`netapp_model`.`cluster_peer`.`updatetime` AS `updatetime`,`netapp_model`.`cluster_peer`.`objState` AS `objState` from `netapp_model`.`cluster_peer`