View ocum.volumeaggregatecapacitymappingview 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
styleExtendedRaw varchar 255  √  null
volumeId bigint 19  √  null
GROUP_CONCAT(volumeAggregateMapping.aggregateid) text 65535  √  null
aggrSizeAvail decimal 41  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `volumeaggregatemapping`.`styleExtendedRaw` AS `styleExtendedRaw`,`volumeaggregatemapping`.`volumeId` AS `volumeId`,group_concat(`volumeaggregatemapping`.`aggregateId` separator ',') AS `GROUP_CONCAT(volumeAggregateMapping.aggregateid)`,sum(`inventoryaggregate`.`sizeAvail`) AS `aggrSizeAvail` from (((select distinct `inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`aggregateId` AS `aggregateId`,`inventoryvolume`.`styleExtendedRaw` AS `styleExtendedRaw` from (`netapp_model`.`volume` `inventoryvolume` straight_join `ocum`.`volume` on(((`inventoryvolume`.`objid` = `ocum`.`volume`.`id`) and (`inventoryvolume`.`objState` = 'LIVE')))) where ((`inventoryvolume`.`aggregateId` is not null) and (`inventoryvolume`.`styleExtendedRaw` = 'flexgroup')) union select distinct `f`.`flexgroupId` AS `volumeId`,`inventoryvolume`.`aggregateId` AS `aggregateId`,'flexgroup' AS `styleExtendedRaw` from ((((select `v`.`objid` AS `objid`,`v`.`aggregateId` AS `aggregateId`,`v`.`styleExtendedRaw` AS `styleExtendedRaw` from `netapp_model`.`volume` `v` where (`v`.`objState` = 'LIVE'))) `inventoryvolume` straight_join `ocum`.`volume` on((`inventoryvolume`.`objid` = `ocum`.`volume`.`id`))) left join `netapp_model`.`volume_flexgroup_constituent_relationship` `f` on((`inventoryvolume`.`objid` = `f`.`objid`))) where (`inventoryvolume`.`styleExtendedRaw` = 'flexgroup_constituent')) `volumeaggregatemapping` straight_join `netapp_model`.`aggregate` `inventoryaggregate` on(((`volumeaggregatemapping`.`aggregateId` = `inventoryaggregate`.`objid`) and (`inventoryaggregate`.`objState` = 'LIVE')))) straight_join `ocum`.`aggregate` on((`inventoryaggregate`.`objid` = `ocum`.`aggregate`.`id`))) group by `volumeaggregatemapping`.`volumeId`
 
Possibly Referenced Tables/Views: