View netapp_model_view.snap_mirror_policy_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 The uuid of the snapmirror policy. DERIVED from {VserverUUID}.{policy name}. If cluster scoped, this will just be the policy name.
resourceKey varchar 512
clusterId bigint 19
vserverId bigint 19  √  null
name varchar 255  √  null The name of the policy.
comment varchar 255  √  null A human readable description associated with the snapmirror policy.
createSnapshot bit 0  √  null Specifies whether a new Snapshot Copy is created at the time of a SnapMirror transfer.
ignoreAccessTime bit 0  √  null Specifies whether incremental transfers will ignore files which have only their access time changed.
isNetworkCompressionEnabled bit 0  √  null Specifies whether network compression is enabled for transfers.
restart enum 11  √  null Defines the behavior of SnapMirror if an interrupted transfer exists - "always" , "never" , "default".
restartRaw varchar 255  √  null Defines the behavior of SnapMirror if an interrupted transfer exists - "always" , "never" , "default".
totalKeep bigint 19  √  null Total retention count for all rules in the policy.
transferPriority enum 10  √  null Specifies the priority at which a SnapMirror transfer runs.
transferPriorityRaw varchar 255  √  null
tries varchar 255  √  null Specifies the maximum number of times to attempt each manual or scheduled transfer for a SnapMirror relationship.
type enum 18  √  null The type of the Snapmirror policy - "vault" , "async_mirror" , "mirror_vault" ,"sync_mirror", "strict_sync_mirror"
typeRaw varchar 255  √  null The type of the Snapmirror policy - "vault" , "async_mirror" , "mirror_vault" ,"sync_mirror"
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`.`snap_mirror_policy`.`objid` AS `objid`,`netapp_model`.`snap_mirror_policy`.`uuid` AS `uuid`,`netapp_model`.`snap_mirror_policy`.`resourceKey` AS `resourceKey`,`netapp_model`.`snap_mirror_policy`.`clusterId` AS `clusterId`,`netapp_model`.`snap_mirror_policy`.`vserverId` AS `vserverId`,`netapp_model`.`snap_mirror_policy`.`name` AS `name`,`netapp_model`.`snap_mirror_policy`.`comment` AS `comment`,`netapp_model`.`snap_mirror_policy`.`createSnapshot` AS `createSnapshot`,`netapp_model`.`snap_mirror_policy`.`ignoreAccessTime` AS `ignoreAccessTime`,`netapp_model`.`snap_mirror_policy`.`isNetworkCompressionEnabled` AS `isNetworkCompressionEnabled`,`netapp_model`.`snap_mirror_policy`.`restart` AS `restart`,`netapp_model`.`snap_mirror_policy`.`restartRaw` AS `restartRaw`,`netapp_model`.`snap_mirror_policy`.`totalKeep` AS `totalKeep`,`netapp_model`.`snap_mirror_policy`.`transferPriority` AS `transferPriority`,`netapp_model`.`snap_mirror_policy`.`transferPriorityRaw` AS `transferPriorityRaw`,`netapp_model`.`snap_mirror_policy`.`tries` AS `tries`,`netapp_model`.`snap_mirror_policy`.`type` AS `type`,`netapp_model`.`snap_mirror_policy`.`typeRaw` AS `typeRaw`,`netapp_model`.`snap_mirror_policy`.`createtime` AS `createTime`,`netapp_model`.`snap_mirror_policy`.`updatetime` AS `updateTime`,`netapp_model`.`snap_mirror_policy`.`objState` AS `objState` from `netapp_model`.`snap_mirror_policy`