Table opm.s_all_volumes_periodic 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
objid bigint 19 0
elementName varchar 255  √  null
elementResourceKey varchar 512  √  null
numberOfHours smallint 5  √  null
derivedStyle enum 11
latency float 12  √  null
ops float 12  √  null
data float 12  √  null
freeCapacity bigint 19  √  null
totalCapacity bigint 19  √  null
clusterId bigint 19  √  null
clusterName varchar 255  √  null
clusterResourceKey varchar 512  √  null
nodeId bigint 19  √  null
nodeName varchar 255  √  null
nodeResourceKey varchar 512  √  null
svmId bigint 19  √  null
svmName varchar 255  √  null
svmResourceKey varchar 512  √  null
aggregateId bigint 19  √  null
aggregateName varchar 255  √  null
aggregateResourceKey varchar 512  √  null
diskType varchar 255  √  null
thresholdPolicyId varchar 512  √  null
thresholdPolicyName text 65535  √  null
tieringPolicy text 65535  √  null
eventSeverity smallint 5  √  null
coldData bigint 19  √  null
cloudRecommendation varchar 255  √  LEARNING
recommendationData json 0  √  null
qosPolicyGroupId bigint 19  √  null
qosPolicyGroup varchar 255  √  null
opsPerTB float 12  √  null
managedByNslm bit 0  √  null
clusterFqdn varchar 255  √  null

Table contained 290 rows at Tue Apr 23 04:58 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
objid Primary key Asc PRIMARY
aggregateName Performance Asc aggregate_name
clusterName Performance Asc cluster_name
elementName Performance Asc element_name
nodeName Performance Asc node_name
svmName Performance Asc svm_name