View ocum_report_birt.volumerelationshiphistorychartview 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
totalCount decimal 33  √  null
successCount decimal 32  √  null
failCount decimal 32  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select `volumerelationshiphistorychartcountview`.`triggerdDate` AS `triggerdDate`,sum((`volumerelationshiphistorychartcountview`.`successCount` + `volumerelationshiphistorychartcountview`.`failCount`)) AS `totalCount`,sum(`volumerelationshiphistorychartcountview`.`successCount`) AS `successCount`,sum(`volumerelationshiphistorychartcountview`.`failCount`) AS `failCount` from `ocum_report_birt`.`volumerelationshiphistorychartcountview` group by `volumerelationshiphistorychartcountview`.`triggerdDate` order by `volumerelationshiphistorychartcountview`.`triggerdDate`
 
Possibly Referenced Tables/Views: