View netapp_model_view.aggregate_objectstore_config_mapping_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.
originid bigint 19
uuid varchar 255 A unique identifier, DERIVED from {aggregate_uuid}.{object_store_uuid}
resourceKey varchar 255
clusterId bigint 19 Foreign key to the cluster table.
binUuid varchar 255  √  null The bin UUID associated with this composite aggregate
aggregateId bigint 19 the aggregate database objid of this composite aggregate
aggregateName varchar 255  √  null the aggregate name of this composite aggregate
tieringFullnessThreshold bigint 19  √  null The value of the tiering-fullness-threshold in percent
objectstoreId bigint 19 the object store database objid associated with this composite aggregate
availabilityState enum 11  √  null Availability state of the composite aggregate
availabilityStateRaw varchar 255  √  null string value of Availability state of the composite aggregate
createTime bigint 19
updateTime bigint 19
objState enum 5  √  null

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`aggregate_objectstore_config_mapping`.`objid` AS `objid`,`netapp_model`.`aggregate_objectstore_config_mapping`.`originid` AS `originid`,`netapp_model`.`aggregate_objectstore_config_mapping`.`uuid` AS `uuid`,`netapp_model`.`aggregate_objectstore_config_mapping`.`resourceKey` AS `resourceKey`,`netapp_model`.`aggregate_objectstore_config_mapping`.`clusterId` AS `clusterId`,`netapp_model`.`aggregate_objectstore_config_mapping`.`binUuid` AS `binUuid`,`netapp_model`.`aggregate_objectstore_config_mapping`.`aggregateId` AS `aggregateId`,`netapp_model`.`aggregate_objectstore_config_mapping`.`aggregateName` AS `aggregateName`,`netapp_model`.`aggregate_objectstore_config_mapping`.`tieringFullnessThreshold` AS `tieringFullnessThreshold`,`netapp_model`.`aggregate_objectstore_config_mapping`.`objectstoreId` AS `objectstoreId`,`netapp_model`.`aggregate_objectstore_config_mapping`.`availabilityState` AS `availabilityState`,`netapp_model`.`aggregate_objectstore_config_mapping`.`availabilityStateRaw` AS `availabilityStateRaw`,`netapp_model`.`aggregate_objectstore_config_mapping`.`createtime` AS `createTime`,`netapp_model`.`aggregate_objectstore_config_mapping`.`updatetime` AS `updateTime`,`netapp_model`.`aggregate_objectstore_config_mapping`.`objState` AS `objState` from `netapp_model`.`aggregate_objectstore_config_mapping`