View ocum.volumeaggregatemappingview 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  √  null
aggregateId bigint 19  √  null
styleExtendedRaw varchar 255  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select distinct `inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`aggregateId` AS `aggregateId`,`inventoryvolume`.`styleExtendedRaw` AS `styleExtendedRaw` from (`netapp_model_view`.`volume` `inventoryvolume` straight_join `ocum`.`volume` on((`inventoryvolume`.`objid` = `ocum`.`volume`.`id`))) where (`inventoryvolume`.`aggregateId` is not null) union select distinct `inventoryvolume`.`flexgroupId` AS `volumeId`,`inventoryvolume`.`aggregateId` AS `aggregateId`,'flexgroup' AS `styleExtendedRaw` from (`netapp_model_view`.`volume` `inventoryvolume` straight_join `ocum`.`volume` on((`inventoryvolume`.`objid` = `ocum`.`volume`.`id`))) where (`inventoryvolume`.`styleExtendedRaw` = 'flexgroup_constituent')
 
Possibly Referenced Tables/Views:
volume