View ocum_report_birt.eventupdatedates | Generated by SchemaSpy |
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: