View netapp_model_view.storage_pool_available_full 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 relationship identifier.ZAPI: storage-pool-spare-capacity-get-iter.storage-pool-spare-capacity-info
uuid varchar 255 The uuid of this relationship. DERIVED:{ClusterUUID}.{NodeUUID}.{StoragePoolName}.
resourceKey varchar 512
clusterId bigint 19
nodeId bigint 19
storagePoolId bigint 19
allocationUnitCount bigint 19 The total number of units which can be allocated as spare capacity for aggregates
allocationUnitSize bigint 19 Minimum size that can be allocated from the storage pool
availableSize bigint 19  √  null
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
syncmirrorPool varchar 255  √  null The name of the syncmirror pool.
createTime bigint 19
updateTime bigint 19
objState enum 5  √  null

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`storage_pool_available`.`objid` AS `objid`,`netapp_model`.`storage_pool_available`.`uuid` AS `uuid`,`netapp_model`.`storage_pool_available`.`resourceKey` AS `resourceKey`,`netapp_model`.`storage_pool_available`.`clusterId` AS `clusterId`,`netapp_model`.`storage_pool_available`.`nodeId` AS `nodeId`,`netapp_model`.`storage_pool_available`.`storagePoolId` AS `storagePoolId`,`netapp_model`.`storage_pool_available`.`allocationUnitCount` AS `allocationUnitCount`,`netapp_model`.`storage_pool_available`.`allocationUnitSize` AS `allocationUnitSize`,`netapp_model`.`storage_pool_available`.`availableSize` AS `availableSize`,`netapp_model`.`storage_pool_available`.`storageType` AS `storageType`,`netapp_model`.`storage_pool_available`.`storageTypeRaw` AS `storageTypeRaw`,`netapp_model`.`storage_pool_available`.`syncmirrorPool` AS `syncmirrorPool`,`netapp_model`.`storage_pool_available`.`createtime` AS `createTime`,`netapp_model`.`storage_pool_available`.`updatetime` AS `updateTime`,`netapp_model`.`storage_pool_available`.`objState` AS `objState` from `netapp_model`.`storage_pool_available`