View netapp_model_view.storage_pool_aggregate_relationship_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-aggregate-get-iter.storage-pool-aggregate-info
uuid varchar 255 The uuid of this relationship. DERIVED:{ClusterUUID}.{StoragePoolName}.{AggregateUUID}.
resourceKey varchar 512
clusterId bigint 19
storagePoolId bigint 19
aggregateId bigint 19
usedCapacity bigint 19  √  null Capacity provisioned by aggregate from storage pool
allocatedUnitCount bigint 19  √  null No of memory units provisioned by aggregate from storage 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_aggregate_relationship`.`objid` AS `objid`,`netapp_model`.`storage_pool_aggregate_relationship`.`uuid` AS `uuid`,`netapp_model`.`storage_pool_aggregate_relationship`.`resourceKey` AS `resourceKey`,`netapp_model`.`storage_pool_aggregate_relationship`.`clusterId` AS `clusterId`,`netapp_model`.`storage_pool_aggregate_relationship`.`storagePoolId` AS `storagePoolId`,`netapp_model`.`storage_pool_aggregate_relationship`.`aggregateId` AS `aggregateId`,`netapp_model`.`storage_pool_aggregate_relationship`.`usedCapacity` AS `usedCapacity`,`netapp_model`.`storage_pool_aggregate_relationship`.`allocatedUnitCount` AS `allocatedUnitCount`,`netapp_model`.`storage_pool_aggregate_relationship`.`createtime` AS `createTime`,`netapp_model`.`storage_pool_aggregate_relationship`.`updatetime` AS `updateTime`,`netapp_model`.`storage_pool_aggregate_relationship`.`objState` AS `objState` from `netapp_model`.`storage_pool_aggregate_relationship`