View ocum.clusternodededicatesparecapacityview 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
node_id bigint 19  √  null
rawBytesDedicatedSpare decimal 41  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `disk`.`ownerNodeId` AS `node_id`,sum(`disk`.`usedBytes`) AS `rawBytesDedicatedSpare` from (`netapp_model_view`.`disk` join `ocum`.`wafldisk` on((`ocum`.`wafldisk`.`id` = `disk`.`objid`))) where (`ocum`.`wafldisk`.`raidState` = 'spare') group by `disk`.`ownerNodeId`
 
Possibly Referenced Tables/Views: