View netapp_model_view.storage_pool 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 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}
resourceKey varchar 512
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
isHealthy bit 0  √  null
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 enum 11  √  null The type of the disks that constitute the storage pool
storageTypeRaw varchar 255  √  null The type of the disks that constitute the storage pool
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`storage_pool`.`objid` AS `objid`,`netapp_model`.`storage_pool`.`uuid` AS `uuid`,`netapp_model`.`storage_pool`.`resourceKey` AS `resourceKey`,`netapp_model`.`storage_pool`.`clusterId` AS `clusterId`,`netapp_model`.`storage_pool`.`name` AS `name`,`netapp_model`.`storage_pool`.`allocationUnitSize` AS `allocationUnitSize`,`netapp_model`.`storage_pool`.`diskCount` AS `diskCount`,`netapp_model`.`storage_pool`.`isHealthy` AS `isHealthy`,`netapp_model`.`storage_pool`.`poolUsableSize` AS `poolUsableSize`,`netapp_model`.`storage_pool`.`poolTotalSize` AS `poolTotalSize`,`netapp_model`.`storage_pool`.`storageType` AS `storageType`,`netapp_model`.`storage_pool`.`storageTypeRaw` AS `storageTypeRaw`,`netapp_model`.`storage_pool`.`createtime` AS `createTime`,`netapp_model`.`storage_pool`.`updatetime` AS `updateTime` from `netapp_model`.`storage_pool` where (`netapp_model`.`storage_pool`.`objState` = 'LIVE')