View ocum.vserverassociationlivelistdtoview 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
id bigint 19
sourceVserverName varchar 255  √  null Textual name
sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
sourceClusterName varchar 255  √  null Textual name
sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
destinationVserverName varchar 255 Textual name
destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
destinationClusterName varchar 255 Textual name
destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
connectionType varchar 32

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `vserverassociation`.`id` AS `id`,`sourcevserver`.`name` AS `sourceVserverName`,`sourcevserver`.`objid` AS `sourceVserverId`,`sourcecluster`.`name` AS `sourceClusterName`,`sourcecluster`.`objid` AS `sourceClusterId`,`destinationvserver`.`name` AS `destinationVserverName`,`destinationvserver`.`objid` AS `destinationVserverId`,`destinationcluster`.`name` AS `destinationClusterName`,`destinationcluster`.`objid` AS `destinationClusterId`,`vserverassociation`.`connectionType` AS `connectionType` from ((((`ocum`.`storageservicevserverdestination` `vserverassociation` left join `netapp_model_view`.`vserver` `sourcevserver` on((`sourcevserver`.`objid` = `vserverassociation`.`sourceVserver_id`))) straight_join `netapp_model_view`.`vserver` `destinationvserver` on((`destinationvserver`.`objid` = `vserverassociation`.`destinationVserver_id`))) left join `netapp_model_view`.`cluster` `sourcecluster` on((`sourcecluster`.`objid` = `sourcevserver`.`clusterId`))) straight_join `netapp_model_view`.`cluster` `destinationcluster` on((`destinationcluster`.`objid` = `destinationvserver`.`clusterId`)))
 
Possibly Referenced Tables/Views: