Table opm.storage_service_level 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  √ 
resource_capability_stats.preferredStorageServiceLevelId fk_preferredStorageServiceLevelId N
workload_provision_mapping.storageServiceLevelId fk_storageServiceLevelId N
workload_provision_mapping.suggestedStorageServiceLevelId fk_suggestedStorageServiceLevelId N
uuid varchar 512
name varchar 255  √  null
description text 65535  √  null Performance policy used to ensure workload performance.
peakIopsPerTB bigint 19 Specifies the maximum possible IOPS per TB allocated based on the storage object used size.
expectedIopsPerTB bigint 19 Specifies the minimum expected IOPS allocated based on the storage object allocated size.
absoluteMinIops bigint 19 100 Indicates the minimum IOPS value for a performance policy.
expectedLatency float 12  √  null
peakIopsAllocationPolicy enum 15 Indicates peak IOPS allocation policy.
conformancePolicyUuid varchar 512  √  null Conformance policy associated with the performance policy.
systemDefined bit 0 0 Indicates if this is a system-provided performance policy.
createTime bigint 19
updateTime bigint 19

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
uuid Must be unique Asc uuid

Close relationships  within of separation: