View ocum_report_birt.basicevents 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
severity int 10
state varchar 16
triggeredTime timestamp 19  √  null
acknowledgedTimestamp timestamp 19  √  null
resolvedTimestamp timestamp 19  √  null
obsoleteTimestamp timestamp 19  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select `ocum`.`eventtypevalue`.`severity` AS `severity`,`ocum`.`event`.`state` AS `state`,`ocum`.`event`.`eventTimestamp` AS `triggeredTime`,`ocum`.`event`.`acknowledgedTimestamp` AS `acknowledgedTimestamp`,`ocum`.`event`.`resolvedTimestamp` AS `resolvedTimestamp`,`ocum`.`event`.`obsoleteTimestamp` AS `obsoleteTimestamp` from ((`ocum`.`event` join `ocum`.`eventtypevalue` on((`ocum`.`event`.`value_id` = `ocum`.`eventtypevalue`.`id`))) join `ocum`.`eventtype` on((`ocum`.`eventtype`.`id` = `ocum`.`eventtypevalue`.`type_id`))) where ((`ocum`.`eventtypevalue`.`severity` in (2,3,4)) and (`ocum`.`eventtype`.`name` not in ('ems.emergency.event','ems.critical.event','ems.warning.event','ems.error.event','ems.informational.event','ems.notice.event','ems.debug.event','ems.alert.event')))