View ocum_report.volumeoutgoingrelationshipview 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
sourceVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `inventoryvolume`.`objid` AS `sourceVolumeId` from `netapp_model_view`.`volume` `inventoryvolume` where exists(select 1 from `netapp_model_view`.`snap_mirror` `inventorysnapmirror` where ((`inventoryvolume`.`objid` = `inventorysnapmirror`.`sourceVolumeId`) and ((`inventorysnapmirror`.`relationshipTypeRaw` = 'data_protection') or (`inventorysnapmirror`.`relationshipTypeRaw` = 'extended_data_protection') or (`inventorysnapmirror`.`relationshipTypeRaw` = 'vault'))))