View netapp_model_view.resource_aggregate_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: aggr-get-iter.aggr-attributes
originid bigint 19
uuid varchar 255 Globally unique ID of the resource headroom aggregate
resourceKey varchar 512 DERIVED. A structured key that may be used to uniquely identify this resource globally.
clusterId bigint 19 Foreign key to the cluster table
aggregateId bigint 19 Foreign key to the aggregate table
aggregateType enum 11  √  null Aggregate Type
createtime bigint 19
updatetime bigint 19
objState enum 5  √  null

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`resource_aggregate`.`objid` AS `objid`,`netapp_model`.`resource_aggregate`.`originid` AS `originid`,`netapp_model`.`resource_aggregate`.`uuid` AS `uuid`,`netapp_model`.`resource_aggregate`.`resourceKey` AS `resourceKey`,`netapp_model`.`resource_aggregate`.`clusterId` AS `clusterId`,`netapp_model`.`resource_aggregate`.`aggregateId` AS `aggregateId`,`netapp_model`.`resource_aggregate`.`aggregateType` AS `aggregateType`,`netapp_model`.`resource_aggregate`.`createtime` AS `createtime`,`netapp_model`.`resource_aggregate`.`updatetime` AS `updatetime`,`netapp_model`.`resource_aggregate`.`objState` AS `objState` from `netapp_model`.`resource_aggregate`