View netapp_model_view.qos_workload_detail 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: perf-object-instance-list-info-iter (with object-name "workload_detail")
uuid varchar 512
resourceKey varchar 512
name varchar 255 Textual name
clusterId bigint 19
workloadId bigint 19 ID of the QoS Workload item associated with this QoS Workload Detail
serviceCenterId bigint 19 ID of the QoS Service Center item associated with this QoS Workload Detail
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`qos_workload_detail`.`objid` AS `objid`,`netapp_model`.`qos_workload_detail`.`uuid` AS `uuid`,`netapp_model`.`qos_workload_detail`.`resourceKey` AS `resourceKey`,`netapp_model`.`qos_workload_detail`.`name` AS `name`,`netapp_model`.`qos_workload_detail`.`clusterId` AS `clusterId`,`netapp_model`.`qos_workload_detail`.`workloadId` AS `workloadId`,`netapp_model`.`qos_workload_detail`.`serviceCenterId` AS `serviceCenterId`,`netapp_model`.`qos_workload_detail`.`createtime` AS `createTime`,`netapp_model`.`qos_workload_detail`.`updatetime` AS `updateTime` from `netapp_model`.`qos_workload_detail` where (`netapp_model`.`qos_workload_detail`.`objState` = 'LIVE')