View ocum.manualannotationbreakdownlivelistdto 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
annotationTypeId bigint 19  √  0
annotationTypeName varchar 255  √  null
healthStatus int 10 0
annotationValueId bigint 19 0
annotationValueName varchar 255
annotationValueFullName varchar 511  √  null
annotationValueHealthStatus int 10 0
clusterCount decimal 23  √  null
vservercount decimal 23  √  null
volumecount decimal 23  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `annotationtypevalueview`.`annotationTypeId` AS `annotationTypeId`,`annotationtypevalueview`.`annotationTypeName` AS `annotationTypeName`,0 AS `healthStatus`,`annotationtypevalueview`.`annotationValueId` AS `annotationValueId`,`annotationtypevalueview`.`annotationValueName` AS `annotationValueName`,concat(`annotationtypevalueview`.`annotationTypeName`,'=',`annotationtypevalueview`.`annotationValueName`) AS `annotationValueFullName`,0 AS `annotationValueHealthStatus`,sum(if((`ocum`.`annotationmanualresourcemapping`.`resourceType` = 'cluster'),1,0)) AS `clusterCount`,sum(if((`ocum`.`annotationmanualresourcemapping`.`resourceType` = 'vserver'),1,0)) AS `vservercount`,sum(if((`ocum`.`annotationmanualresourcemapping`.`resourceType` = 'volume'),1,0)) AS `volumecount` from (`ocum`.`annotationtypevalueview` left join `ocum`.`annotationmanualresourcemapping` on(((`annotationtypevalueview`.`annotationTypeId` = `ocum`.`annotationmanualresourcemapping`.`annotationTypeId`) and (`annotationtypevalueview`.`annotationValueId` = `ocum`.`annotationmanualresourcemapping`.`annotationValueId`)))) group by `annotationtypevalueview`.`annotationTypeName`,`annotationtypevalueview`.`annotationValueName`
 
Possibly Referenced Tables/Views: