Table opm.resource_capability_stats 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
id bigint 19  √ 
clusterId bigint 19
resourceId bigint 19  √  null
resourceType smallint 5  √  null
element_type_definition.id fk_resourceType C
iopsSeed bigint 19  √  null
preferredStorageServiceLevelId bigint 19  √  null
storage_service_level.id fk_preferredStorageServiceLevelId N
statStartTime bigint 19  √  null
statEndTime bigint 19  √  null
iops95th float 12  √  null
iopsAvg float 12  √  null
iopsMedian float 12  √  null
iopsMax float 12  √  null
iopsCustom float 12  √  null IOPS custom percentile, can be modified based on requirement
estIops95th float 12  √  null
estIopsAvg float 12  √  null
estIopsMedian float 12  √  null
estIopsMax float 12  √  null
estIopsCustom float 12  √  null Estimated IOPS custom percentile, can be modified based on requirement
budgetedIops float 12  √  null
maxBudgetedIops float 12  √  null
budgetedNoSslIops float 12  √  null
maxBudgetedNoSslIops float 12  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
preferredStorageServiceLevelId Performance Asc fk_preferredStorageServiceLevelId  
resourceType Performance Asc fk_resourceType  
clusterId Performance Asc k_clusterId  
resourceId Must be unique Asc uk_resourceId This unique column is also nullable

Close relationships  within of separation: