View netapp_model_view.sis_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 sis policy. DERIVED from {VserverUUID}.{policy name}
resourceKey varchar 512
name varchar 255 The name of the sis policy.
vserverId bigint 19
clusterId bigint 19
jobScheduleId bigint 19  √  null
isEnabled bit 0  √  null If the value is true, the sis policy is active and sis operations will be triggered on the volume on the specified schedule
comment varchar 255  √  null A brief description of the policy.
duration varchar 255  √  null The duration in hours for which the scheduled sis operation should run
qosPolicy enum 11  √  null QoS policy for the sis operation.
qosPolicyRaw varchar 255  √  null
policyType enum 11  √  null The policy type reflects the reason a volume using this policy will start processing a changelog.
policyTypeRaw varchar 255  √  null Raw value of policyType.
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`.`sis_policy`.`objid` AS `objid`,`netapp_model`.`sis_policy`.`uuid` AS `uuid`,`netapp_model`.`sis_policy`.`resourceKey` AS `resourceKey`,`netapp_model`.`sis_policy`.`name` AS `name`,`netapp_model`.`sis_policy`.`vserverId` AS `vserverId`,`netapp_model`.`sis_policy`.`clusterId` AS `clusterId`,`netapp_model`.`sis_policy`.`jobScheduleId` AS `jobScheduleId`,`netapp_model`.`sis_policy`.`isEnabled` AS `isEnabled`,`netapp_model`.`sis_policy`.`comment` AS `comment`,`netapp_model`.`sis_policy`.`duration` AS `duration`,`netapp_model`.`sis_policy`.`qosPolicy` AS `qosPolicy`,`netapp_model`.`sis_policy`.`qosPolicyRaw` AS `qosPolicyRaw`,`netapp_model`.`sis_policy`.`policyType` AS `policyType`,`netapp_model`.`sis_policy`.`policyTypeRaw` AS `policyTypeRaw`,`netapp_model`.`sis_policy`.`createtime` AS `createTime`,`netapp_model`.`sis_policy`.`updatetime` AS `updateTime`,`netapp_model`.`sis_policy`.`objState` AS `objState` from `netapp_model`.`sis_policy`