Table opm.s_all_luns_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
name varchar 255  √  null
resourceKey varchar 512  √  null
numberOfHours smallint 5  √  null
latency float 12  √  null
ops float 12  √  null
throughput 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
volumeId bigint 19  √  null
volumeName varchar 255  √  null
volumeResourceKey varchar 512  √  null
thresholdPolicyId varchar 512  √  null
thresholdPolicyName text 65535  √  null
eventSeverity smallint 5  √  null
qosPolicyGroupId bigint 19  √  null
qosPolicyGroup varchar 255  √  null
clusterFqdn varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
objid Primary key Asc PRIMARY
name Performance Asc aggregate_name
clusterName Performance Asc cluster_name
nodeName Performance Asc node_name
svmName Performance Asc svm_name
volumeName Performance Asc volume_name