View ocum_report.protectunprotectvolumeview 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
name varchar 255 Textual name
protectionrole varchar 52  √  null
clusternodeName varchar 255  √  null Textual name
clustername varchar 255 Textual name

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `volumelivelistdtoview`.`name` AS `name`,concat(upper(substr(`volumelivelistdtoview`.`protectionRole`,1,1)),lower(substr(`volumelivelistdtoview`.`protectionRole`,2))) AS `protectionrole`,`volumelivelistdtoview`.`clusterNodeName` AS `clusternodeName`,`volumelivelistdtoview`.`clusterName` AS `clustername` from `ocum`.`volumelivelistdtoview` where (`volumelivelistdtoview`.`protectionRole` in ('protected','unprotected','destination'))