View ocum.diskaggregaterelationshipaggrcountview 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
diskId bigint 19  √  null
aggrCount bigint 19 0

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `dar`.`lastKnownDiskId` AS `diskId`,count(`dar`.`lastKnownAggregateId`) AS `aggrCount` from (`netapp_model_view`.`disk` `inventorydisk` left join `ocum`.`diskaggregaterelationship` `dar` on((`dar`.`lastKnownDiskId` = `inventorydisk`.`objid`))) where (`dar`.`lastKnownDiskId` is not null) group by `diskId`
 
Possibly Referenced Tables/Views: