View ocum_report_birt.eventseveritytrendchart 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
triggeredDate date 10  √  null
errorCount bigint unsigned 20  √  null
criticalCount bigint unsigned 20  √  null
warningCount bigint unsigned 20  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select `eventseveritytrendhelper`.`triggeredDate` AS `triggeredDate`,cast(sum((case when (`eventseveritytrendhelper`.`severity` = 3) then `eventseveritytrendhelper`.`numberOfEvents` else 0 end)) as unsigned) AS `errorCount`,cast(sum((case when (`eventseveritytrendhelper`.`severity` = 4) then `eventseveritytrendhelper`.`numberOfEvents` else 0 end)) as unsigned) AS `criticalCount`,cast(sum((case when (`eventseveritytrendhelper`.`severity` = 2) then `eventseveritytrendhelper`.`numberOfEvents` else 0 end)) as unsigned) AS `warningCount` from `ocum_report_birt`.`eventseveritytrendhelper` group by `eventseveritytrendhelper`.`triggeredDate`
 
Possibly Referenced Tables/Views: