View netapp_model_view.snapshot_policy_schedule 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 schedule. DERIVED from {ClusterUUID}.{VserverUUID}.{snapshotPolicy.name}.{schedule.prefix}.
resourceKey varchar 512
snapshotPolicyId bigint 19
clusterId bigint 19
jobScheduleId bigint 19  √  null
prefix varchar 255  √  null Snapshot name prefix for the schedule present in the snapshot policy.
snapMirrorLabel varchar 255  √  null Snapshot SnapMirror Label for the schedule present in the snapshot policy.
count bigint 19  √  null Maximum number of snapshots to retain for the schedule present in the snapshot policy.
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`snapshot_policy_schedule`.`objid` AS `objid`,`netapp_model`.`snapshot_policy_schedule`.`uuid` AS `uuid`,`netapp_model`.`snapshot_policy_schedule`.`resourceKey` AS `resourceKey`,`netapp_model`.`snapshot_policy_schedule`.`snapshotPolicyId` AS `snapshotPolicyId`,`netapp_model`.`snapshot_policy_schedule`.`clusterId` AS `clusterId`,`netapp_model`.`snapshot_policy_schedule`.`jobScheduleId` AS `jobScheduleId`,`netapp_model`.`snapshot_policy_schedule`.`prefix` AS `prefix`,`netapp_model`.`snapshot_policy_schedule`.`snapMirrorLabel` AS `snapMirrorLabel`,`netapp_model`.`snapshot_policy_schedule`.`count` AS `count`,`netapp_model`.`snapshot_policy_schedule`.`createtime` AS `createTime`,`netapp_model`.`snapshot_policy_schedule`.`updatetime` AS `updateTime` from `netapp_model`.`snapshot_policy_schedule` where (`netapp_model`.`snapshot_policy_schedule`.`objState` = 'LIVE')