View netapp_model_view.snapshot_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 snapshot policy. DERIVED from {ClusterUUID}.{VserverUUID}.{policy name}. If cluster scoped, this will just be the policy name.
resourceKey varchar 512
name varchar 255 A human readable string describing the name of the snapshot scheduling policy.
vserverId bigint 19  √  null ID of the vserver that this Snapshot Policy is associated with.
clusterId bigint 19
isEnabled bit 0  √  null The state of the snapshot policy. If true, the snapshot policy is enabled and scheduled snapshots will be created on the volume associated with this policy.
comment varchar 255  √  null A human readable description associated with the snasphot policy.
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 `sp`.`objid` AS `objid`,`sp`.`uuid` AS `uuid`,`sp`.`resourceKey` AS `resourceKey`,`sp`.`name` AS `name`,`spv`.`vserverId` AS `vserverId`,`sp`.`clusterId` AS `clusterId`,`sp`.`isEnabled` AS `isEnabled`,`sp`.`comment` AS `comment`,`sp`.`createtime` AS `createTime`,`sp`.`updatetime` AS `updateTime`,`sp`.`objState` AS `objState` from (`netapp_model`.`snapshot_policy` `sp` left join `netapp_model`.`snapshot_policy_vserver_relationship` `spv` on((`sp`.`objid` = `spv`.`objid`)))