View netapp_model_view.qos_volume_workload 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 Locally unique object identifier. ZAPIs: qos-workload-get-iter.qos-workload-info
uuid varchar 255 Globally unique ID of the QoS Workload
resourceKey varchar 512
name varchar 255 Textual name
clusterId bigint 19
vserverId bigint 19  √  null ID of the vserver the workload is associated with
volumeId bigint 19  √  null
workloadClass enum 14 Identifies how the workload was created
workloadClassRaw varchar 255  √  null Identifies how the workload was created - ZAPI raw value
isAdaptive bit 0 0 indicates if workload is belong to adaptive QoS policy group
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `qos_workload`.`objid` AS `objid`,`qos_workload`.`uuid` AS `uuid`,`qos_workload`.`resourceKey` AS `resourceKey`,`qos_workload`.`name` AS `name`,`qos_workload`.`clusterId` AS `clusterId`,`qos_workload`.`vserverId` AS `vserverId`,`qos_workload`.`holderId` AS `volumeId`,`qos_workload`.`workloadClass` AS `workloadClass`,`qos_workload`.`workloadClassRaw` AS `workloadClassRaw`,`qos_workload`.`isAdaptive` AS `isAdaptive`,`qos_workload`.`createTime` AS `createTime`,`qos_workload`.`updateTime` AS `updateTime` from `netapp_model_view`.`qos_workload` where (`qos_workload`.`holderType` = 'VOLUME')
 
Possibly Referenced Tables/Views: