View netapp_model_view.snap_mirror_policy_rule_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 rule. DERIVED from {SnapmirrorPolicyUUID}.{ordinalIndex}.
resourceKey varchar 512
clusterId bigint 19
snapMirrorPolicyId bigint 19
keep varchar 255  √  null Specifies the snapmirror copy retention count.
preserve bit 0  √  null Specifies whether snapmirror copy preserve is enabled
snapMirrorLabel varchar 255  √  null Specifies the snapmirror copy label.
warn bigint 19  √  null Specifies the warning threshold count.
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_rule`.`objid` AS `objid`,`netapp_model`.`snap_mirror_policy_rule`.`uuid` AS `uuid`,`netapp_model`.`snap_mirror_policy_rule`.`resourceKey` AS `resourceKey`,`netapp_model`.`snap_mirror_policy_rule`.`clusterId` AS `clusterId`,`netapp_model`.`snap_mirror_policy_rule`.`snapMirrorPolicyId` AS `snapMirrorPolicyId`,`netapp_model`.`snap_mirror_policy_rule`.`keep` AS `keep`,`netapp_model`.`snap_mirror_policy_rule`.`preserve` AS `preserve`,`netapp_model`.`snap_mirror_policy_rule`.`snapMirrorLabel` AS `snapMirrorLabel`,`netapp_model`.`snap_mirror_policy_rule`.`warn` AS `warn`,`netapp_model`.`snap_mirror_policy_rule`.`createtime` AS `createTime`,`netapp_model`.`snap_mirror_policy_rule`.`updatetime` AS `updateTime`,`netapp_model`.`snap_mirror_policy_rule`.`objState` AS `objState` from `netapp_model`.`snap_mirror_policy_rule`