View netapp_model_view.objectstore_space_detail 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: aggr-cluster-space-details-get.cluster-space-info.licensed-capacity-tier-details.licensed-capacity-tier-info OR aggr-cluster-space-details-get.cluster-space-info.unlicensed-capacity-tier-details.unlicensed-capacity-tier-info
uuid varchar 255 Globally unique ID of the capacity tier space detail = clusterUuid.providerType.
resourceKey varchar 512
clusterId bigint 19
providerType enum 13  √  null Type of object store provider
providerTypeRaw varchar 255  √  null raw provider type associated with capacity tier
isLicensed bit 0  √  null Indicates if the capacity tier is licensed or unlicensed
usedSpace bigint 19 used space of the capacity tier
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`objectstore_space_detail`.`objid` AS `objid`,`netapp_model`.`objectstore_space_detail`.`uuid` AS `uuid`,`netapp_model`.`objectstore_space_detail`.`resourceKey` AS `resourceKey`,`netapp_model`.`objectstore_space_detail`.`clusterId` AS `clusterId`,`netapp_model`.`objectstore_space_detail`.`providerType` AS `providerType`,`netapp_model`.`objectstore_space_detail`.`providerTypeRaw` AS `providerTypeRaw`,`netapp_model`.`objectstore_space_detail`.`isLicensed` AS `isLicensed`,`netapp_model`.`objectstore_space_detail`.`usedSpace` AS `usedSpace`,`netapp_model`.`objectstore_space_detail`.`createTime` AS `createTime`,`netapp_model`.`objectstore_space_detail`.`updateTime` AS `updateTime` from `netapp_model`.`objectstore_space_detail` where (`netapp_model`.`objectstore_space_detail`.`objState` = 'LIVE')