View ocum_report_birt.eventseveritytrendhelper 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
severity int 10
numberOfEvents bigint 19 0

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select cast(`basicevents`.`triggeredTime` as date) AS `triggeredDate`,`basicevents`.`severity` AS `severity`,count(0) AS `numberOfEvents` from `ocum_report_birt`.`basicevents` group by `basicevents`.`severity`,`triggeredDate`
 
Possibly Referenced Tables/Views: