View ocum_report.storagepool 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 Locally unique object identifier. ZAPI: storage-pool-get-iter.storage-pool-info
uuid varchar 255 Globally unique ID of the storage pool. DERIVED: {ClusterUUID}.{StoragePoolName}
clusterId bigint 19
name varchar 255 The cluster-wide unique name of the storage pool.
allocationUnitSize bigint 19 Minimum size that can be allocated from the storage pool.
diskCount bigint 19 The number of disks that are part of the storage pool
poolUsableSize bigint 19  √  null The amount of usable size in bytes in the storage pool.
poolTotalSize bigint 19  √  null The total size of the storage pool.
storageType varchar 255  √  null The type of the disks that constitute the storage pool

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `storage_pool`.`objid` AS `id`,`storage_pool`.`uuid` AS `uuid`,`storage_pool`.`clusterId` AS `clusterId`,`storage_pool`.`name` AS `name`,`storage_pool`.`allocationUnitSize` AS `allocationUnitSize`,`storage_pool`.`diskCount` AS `diskCount`,`storage_pool`.`poolUsableSize` AS `poolUsableSize`,`storage_pool`.`poolTotalSize` AS `poolTotalSize`,`storage_pool`.`storageTypeRaw` AS `storageType` from `netapp_model_view`.`storage_pool`