View ocum_report_birt.volumerelationshiphistorychartcountview 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
triggerdDate varchar 10  √  null
successCount int 10 0
failCount int 10 0

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select date_format(`volumerelationshiphistoryview`.`startTime`,'%Y-%m-%d') AS `triggerdDate`,(case when (`volumerelationshiphistoryview`.`operationResult` = 'success') then 1 else 0 end) AS `successCount`,(case when (`volumerelationshiphistoryview`.`operationResult` <> 'success') then 1 else 0 end) AS `failCount` from `ocum_report_birt`.`volumerelationshiphistoryview`
 
Possibly Referenced Tables/Views: