View netapp_model_view.disk_aggregate_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 relationship identifier. ZAPI: aggr-status-get-iter aggr-status-info.aggr-plex-info.aggr-raidgroup-info
uuid varchar 255 The uuid of this relationship. DERIVED:{DiskUUID}.{AggregateUUID}
resourceKey varchar 512
clusterId bigint 19
diskId bigint 19
aggregateId bigint 19
isCache bit 0  √  null indicating if the disk is used as cache.
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`disk_aggregate_relationship`.`objid` AS `objid`,`netapp_model`.`disk_aggregate_relationship`.`uuid` AS `uuid`,`netapp_model`.`disk_aggregate_relationship`.`resourceKey` AS `resourceKey`,`netapp_model`.`disk_aggregate_relationship`.`clusterId` AS `clusterId`,`netapp_model`.`disk_aggregate_relationship`.`diskId` AS `diskId`,`netapp_model`.`disk_aggregate_relationship`.`aggregateId` AS `aggregateId`,`netapp_model`.`disk_aggregate_relationship`.`isCache` AS `isCache`,`netapp_model`.`disk_aggregate_relationship`.`createtime` AS `createTime`,`netapp_model`.`disk_aggregate_relationship`.`updatetime` AS `updateTime` from `netapp_model`.`disk_aggregate_relationship` where (`netapp_model`.`disk_aggregate_relationship`.`objState` = 'LIVE')