View netapp_model_view.qos_service_center_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: perf-object-instance-list-info-iter (with object-name "resource")
uuid varchar 512
resourceKey varchar 512
name varchar 255 Textual name
clusterId bigint 19
nodeId bigint 19
aggregateId bigint 19  √  null Optional ID of the Aggregate the service center is associated with
parentResourceId bigint 19  √  null ID of the parent service center
type enum 12 Identifies whether the service center is a resource or a delay center
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 `sc`.`objid` AS `objid`,`sc`.`uuid` AS `uuid`,`sc`.`resourceKey` AS `resourceKey`,`sc`.`name` AS `name`,`sc`.`clusterId` AS `clusterId`,`sc`.`nodeId` AS `nodeId`,`sc`.`aggregateId` AS `aggregateId`,`scr`.`parentQosServiceCenterId` AS `parentResourceId`,`sc`.`type` AS `type`,`sc`.`createtime` AS `createTime`,`sc`.`updatetime` AS `updateTime`,`sc`.`objState` AS `objState` from (`netapp_model`.`qos_service_center` `sc` left join `netapp_model`.`qos_service_center_relationship` `scr` on((`sc`.`objid` = `scr`.`objid`)))