View ocum.lunnodecapacitymapping 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
isLunMapped int 10  √  null
nodeId bigint 19  √  null
assignedLunCapacity decimal 41  √  null
unassignedLunCapacity decimal 41  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select if(isnull(`lun`.`isMapped`),0,`lun`.`isMapped`) AS `isLunMapped`,`inventoryvolume`.`nodeId` AS `nodeId`,sum((case when (`lun`.`isMapped` is true) then `lun`.`size` else 0 end)) AS `assignedLunCapacity`,sum((case when (`lun`.`isMapped` is false) then `lun`.`size` when isnull(`lun`.`isMapped`) then `lun`.`size` else 0 end)) AS `unassignedLunCapacity` from (`netapp_model_view`.`lun` left join `netapp_model_view`.`volume` `inventoryvolume` on((`inventoryvolume`.`objid` = `lun`.`volumeId`))) group by `isLunMapped`,`inventoryvolume`.`nodeId`
 
Possibly Referenced Tables/Views:
lun