View netapp_model_view.qos_workload_node_relationship 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.
uuid varchar 255 Globally unique ID of the relationship
resourceKey varchar 512
clusterId bigint 19
nodeId bigint 19 ID of the Node
workloadId bigint 19 ID of the QoS Workload
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

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