Table opm.workload_provision_mapping 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
workloadId bigint 19  √  null
workloadKey varchar 255  √  null
workloadType smallint 5  √  null
element_type_definition.id fk_workloadType C
storageServiceLevelId bigint 19  √  null
storage_service_level.id fk_storageServiceLevelId N
suggestedStorageServiceLevelId bigint 19  √  null
storage_service_level.id fk_suggestedStorageServiceLevelId N
storageServiceLevelStatus enum 45 IDLE
provisioningPolicyId bigint 19  √  null
provisioningPolicyStatus enum 5  √  null
qosPolicyGroupId bigint 19  √  null
nonConformingData float 12  √  null
lastSslUpdateTime bigint 19  √  null
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
latency95th float 12  √  null
latencyAvg float 12  √  null
latencyMedian float 12  √  null
latencyMax float 12  √  null
latencyCustom float 12  √  null Latency custom percentile, can be modified based on requirement
capUsed95th float 12  √  null
capUsedAvg float 12  √  null
capUsedMedian float 12  √  null
capUsedMax float 12  √  null
capUsedCustom float 12  √  null Capacity used custom percentile, can be modified based on requirement
budgetedIops float 12  √  null
maxBudgetedIops float 12  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
storageServiceLevelId Performance Asc fk_storageServiceLevelId  
suggestedStorageServiceLevelId Performance Asc fk_suggestedStorageServiceLevelId  
workloadType Performance Asc fk_workloadType  
clusterId Performance Asc k_clusterId  
workloadId Must be unique Asc uk_workloadId This unique column is also nullable
workloadKey Must be unique Asc uk_workloadKey This unique column is also nullable

Close relationships  within of separation: