View ocum_report_birt.daywiseeventstatustrendchart 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
lastUpdatedTime date 10  √  null
newCount decimal 44  √  null
ackCount decimal 43  √  null
resolvedCount bigint 19  √  null
obsoleteCount bigint 19  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select `helper1`.`lastUpdatedTime` AS `lastUpdatedTime`,(sum(`helper2`.`newCount`) - (sum(`helper2`.`ackCount`) + sum(`helper2`.`newToResolvedAndObsoleteCount`))) AS `newCount`,(sum(`helper2`.`ackCount`) - sum(`helper2`.`ackToResolvedAndObsoleteCount`)) AS `ackCount`,(select count(0) from `ocum_report_birt`.`basicevents` where (cast(`basicevents`.`resolvedTimestamp` as date) = `helper1`.`lastUpdatedTime`)) AS `resolvedCount`,(select count(0) from `ocum_report_birt`.`basicevents` where (cast(`basicevents`.`obsoleteTimestamp` as date) = `helper1`.`lastUpdatedTime`)) AS `obsoleteCount` from (`ocum_report_birt`.`eventstatecharthelper` `helper1` join `ocum_report_birt`.`eventstatecharthelper` `helper2` on((`helper2`.`lastUpdatedTime` <= `helper1`.`lastUpdatedTime`))) group by `helper1`.`lastUpdatedTime`
 
Possibly Referenced Tables/Views: