View ocum_report.storagepoolaggregatemapping 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 relationship identifier. ZAPI:storage-pool-aggregate-get-iter.storage-pool-aggregate-info
uuid varchar 255 The uuid of this relationship. DERIVED:{ClusterUUID}.{StoragePoolName}.{AggregateUUID}.
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

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `storage_pool_aggregate_relationship`.`objid` AS `id`,`storage_pool_aggregate_relationship`.`uuid` AS `uuid`,`storage_pool_aggregate_relationship`.`clusterId` AS `clusterId`,`storage_pool_aggregate_relationship`.`storagePoolId` AS `storagePoolId`,`storage_pool_aggregate_relationship`.`aggregateId` AS `aggregateId`,`storage_pool_aggregate_relationship`.`usedCapacity` AS `usedCapacity`,`storage_pool_aggregate_relationship`.`allocatedUnitCount` AS `allocatedUnitCount` from `netapp_model_view`.`storage_pool_aggregate_relationship`