Table opm.new_s_all_aggregates_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
aggregateType varchar 255  √  null
aggregateDerivedType varchar 255  √  null
numberOfHours smallint 5  √  null
latency float 12  √  null
ops float 12  √  null
throughput float 12  √  null
aggregateUtilization float 12  √  null
usedHeadroom float 12  √  null
availableOps float 12  √  null
freeCapacity bigint 19  √  null
totalCapacity bigint 19  √  null
isInactiveDataReportingEnabled varchar 255  √  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
thresholdPolicyId varchar 512  √  null
thresholdPolicyName text 65535  √  null
eventSeverity smallint 5  √  null
clusterFqdn varchar 255  √  null

Table contained 7 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