View ocum.clusternodedowneventsview 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
node_id bigint 19
downTimestamp timestamp 19  √  null
eventName varchar 255

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `ocum`.`event`.`source_id` AS `node_id`,`ocum`.`event`.`eventTimestamp` AS `downTimestamp`,`ocum`.`eventtypevalue`.`uniqueName` AS `eventName` from (`ocum`.`event` join `ocum`.`eventtypevalue` on((`ocum`.`event`.`value_id` = `ocum`.`eventtypevalue`.`id`))) where ((`ocum`.`event`.`state` in ('NEW','ACKNOWLEDGED')) and (`ocum`.`eventtypevalue`.`uniqueName` = 'storage-failover-node-status-down'))
 
Possibly Referenced Tables/Views: