View netapp_model_view.storage_service_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
uuid varchar 255 Globally unique ID of the Storage Service. DERIVED from {volumeUUID}.{storageServiceIdentifier}.
resourceKey varchar 512 DERIVED. A structured key that may be used to uniquely identify this resource globally.
clusterId bigint 19
vserverId bigint 19
volumeId bigint 19  √  null ID of the volume the storage service references
storageServiceIdentifier bigint 19 Storage Service ID. ZAPIs: volume-storage-service-get-iter.storage-service-info.storage-service-id
storageServiceName varchar 255  √  null Storage Service Name. ZAPIs: volume-storage-service-get-iter.storage-service-info.storage-service
sizeUsed bigint 19  √  null Derived. Sum of sizeUsed over all constituent volumes assigned to this service. In bytes.
sizeTotal bigint 19  √  null Derived. Sum of sizeTotal over all constituent volumes assigned to this service. In bytes.
sizeUsedBySnapshots bigint 19  √  null Derived. Sum of sizeUsedBySnapshots over all constituent volumes assigned to this service. In bytes.
snapshotReserveSize bigint 19  √  null Derived. Sum of snapshotReserveSize over all constituent volumes assigned to this service. In bytes.
deduplicationSpaceSaved bigint 19  √  null Derived. Sum of deduplicationSpaceSaved over all constituent volumes assigned to this service. In bytes.
compressionSpaceSaved bigint 19  √  null Derived. Sum of compressionSpaceSaved over all constituent volumes assigned to this service. In bytes.
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `service`.`objid` AS `objid`,`service`.`UUID` AS `uuid`,`service`.`resourceKey` AS `resourceKey`,`service`.`clusterId` AS `clusterId`,`service`.`vserverId` AS `vserverId`,`ssv`.`volumeId` AS `volumeId`,`service`.`storageServiceIdentifier` AS `storageServiceIdentifier`,`service`.`storageServiceName` AS `storageServiceName`,`service`.`sizeUsed` AS `sizeUsed`,`service`.`sizeTotal` AS `sizeTotal`,`service`.`sizeUsedBySnapshots` AS `sizeUsedBySnapshots`,`service`.`snapshotReserveSize` AS `snapshotReserveSize`,`service`.`deduplicationSpaceSaved` AS `deduplicationSpaceSaved`,`service`.`compressionSpaceSaved` AS `compressionSpaceSaved`,`service`.`createtime` AS `createTime`,`service`.`updatetime` AS `updateTime`,`service`.`objState` AS `objState` from (`netapp_model`.`storage_service` `service` left join `netapp_model`.`storage_service_volume_relationship` `ssv` on((`service`.`objid` = `ssv`.`objid`)))