View ocum_report_birt.eventupdatedates 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

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select cast(`basicevents`.`triggeredTime` as date) AS `lastUpdatedTime` from `ocum_report_birt`.`basicevents` union select cast(`basicevents`.`acknowledgedTimestamp` as date) AS `lastUpdatedTime` from `ocum_report_birt`.`basicevents` union select cast(`basicevents`.`resolvedTimestamp` as date) AS `lastUpdatedTime` from `ocum_report_birt`.`basicevents` union select cast(`basicevents`.`obsoleteTimestamp` as date) AS `lastUpdatedTime` from `ocum_report_birt`.`basicevents` order by `lastUpdatedTime`
 
Possibly Referenced Tables/Views: