View ocum.flexvolcalculationsview 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
volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
isPrimary int 10 0

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `volume`.`objid` AS `volumeId`,(case when (((`volume`.`volTypeRaw` = 'rw') and isnull(`snap_mirror`.`objid`)) = TRUE) then TRUE else FALSE end) AS `isPrimary` from (`netapp_model_view`.`volume` left join `netapp_model_view`.`snap_mirror` on((`volume`.`objid` = `snap_mirror`.`destinationVolumeId`)))
 
Possibly Referenced Tables/Views:
volume