View netapp_model_view.qos_volume_workload_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 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
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

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