View netapp_model_view.snapshot_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 snapshot. Not available in ZAPI. Uses {VolumeUUID}.{SnapshotInstanceUUID}
resourceKey varchar 512
volumeId bigint 19
vserverId bigint 19
clusterId bigint 19
instanceUUID varchar 255  √  null The 128 bit unique snapshot identifier expressed in the form of UUID. This field uniquely identifies the snapshot's physical data layout. ZAPI: snapshot-get-ter snapshot-info snapshot-instance-uuid
versionUUID varchar 255  √  null The 128 bit unique snapshot identifier expressed in the form of UUID. This field uniquely identifies the snapshot's logical data layout. ZAPI: snapshot-get-ter snapshot-info snapshot-version-uuid
name varchar 255 Name of the snapshot. ZAPI: snapshot-get-ter snapshot-info name
isBusy bit 0  √  null True if the snapshot is being used by an application. ZAPI: snapshot-get-ter snapshot-info busy
accessTime timestamp 19  √  null The volume access time when the snapshot was created in seconds since Jan 1, 1970. This value will not change even if the snapshot is accessed. ZAPI: snapshot-get-ter snapshot-info access-time
dependency varchar 255  √  null Application(s) dependent on this snapshot. ZAPI: snapshot-get-ter snapshot-info dependency
percentageOfTotalBlocks int 10  √  null Percentage of blocks owned by this snapshot, relative to the total number of blocks in the volume. ZAPI: snapshot-get-ter snapshot-info percentage-of-total-blocks
cumulativePercentageOfTotalBlocks int 10  √  null Percentage of blocks owned by this snapshot and all more recent snapshots, relative to the total number of blocks in the volume. snapshot-get-ter snapshot-info cumulative-percentage-of-total-blocks
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 `netapp_model`.`snapshot`.`objid` AS `objid`,`netapp_model`.`snapshot`.`uuid` AS `uuid`,`netapp_model`.`snapshot`.`resourceKey` AS `resourceKey`,`netapp_model`.`snapshot`.`volumeId` AS `volumeId`,`netapp_model`.`snapshot`.`vserverId` AS `vserverId`,`netapp_model`.`snapshot`.`clusterId` AS `clusterId`,`netapp_model`.`snapshot`.`instanceUUID` AS `instanceUUID`,`netapp_model`.`snapshot`.`versionUUID` AS `versionUUID`,`netapp_model`.`snapshot`.`name` AS `name`,`netapp_model`.`snapshot`.`isBusy` AS `isBusy`,`netapp_model`.`snapshot`.`accessTime` AS `accessTime`,`netapp_model`.`snapshot`.`dependency` AS `dependency`,`netapp_model`.`snapshot`.`percentageOfTotalBlocks` AS `percentageOfTotalBlocks`,`netapp_model`.`snapshot`.`cumulativePercentageOfTotalBlocks` AS `cumulativePercentageOfTotalBlocks`,`netapp_model`.`snapshot`.`createtime` AS `createTime`,`netapp_model`.`snapshot`.`updatetime` AS `updateTime`,`netapp_model`.`snapshot`.`objState` AS `objState` from `netapp_model`.`snapshot`