View ocum.luncountperigrouplistdtoview 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
igroupId bigint 19  √  null
LUNMappedIgroup bigint 19 0
mappedLunIdentifier text 65535  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventorylunmap`.`igroupId` AS `igroupId`,count(`inventorylunmap`.`lunId`) AS `LUNMappedIgroup`,group_concat(`inventorylunmap`.`lun` separator ',') AS `mappedLunIdentifier` from `netapp_model_view`.`lun_map` `inventorylunmap` group by `inventorylunmap`.`igroupId`