View ocum_report_birt.newtoresolvedandobsoleteevents 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
eventsCount bigint 19 0
state varchar 11

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select cast(coalesce(`basicevents`.`resolvedTimestamp`,`basicevents`.`obsoleteTimestamp`) as date) AS `lastUpdatedTime`,count(0) AS `eventsCount`,'NEW-RES/OBS' AS `state` from `ocum_report_birt`.`basicevents` where (isnull(`basicevents`.`acknowledgedTimestamp`) and ((`basicevents`.`resolvedTimestamp` is not null) or (isnull(`basicevents`.`resolvedTimestamp`) and (`basicevents`.`obsoleteTimestamp` is not null)))) group by `lastUpdatedTime`
 
Possibly Referenced Tables/Views: