View ocum_report_birt.newevents 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 3

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select cast(`basicevents`.`triggeredTime` as date) AS `lastUpdatedTime`,count(0) AS `eventsCount`,'NEW' AS `state` from `ocum_report_birt`.`basicevents` group by `lastUpdatedTime`
 
Possibly Referenced Tables/Views: