View ocum_report.aggregateobjectstoremapping 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
id bigint 19 Locally unique object identifier.
uuid varchar 255 A unique identifier, DERIVED from {aggregate_uuid}.{object_store_uuid}
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
objectstoreId bigint 19 the object store database objid associated with this composite aggregate
AvailabilityStatus varchar 255  √  null string value of Availability state of the composite aggregate
createTime bigint 19

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `aggregate_objectstore_config_mapping`.`objid` AS `id`,`aggregate_objectstore_config_mapping`.`uuid` AS `uuid`,`aggregate_objectstore_config_mapping`.`clusterId` AS `clusterId`,`aggregate_objectstore_config_mapping`.`binUuid` AS `binUuid`,`aggregate_objectstore_config_mapping`.`aggregateId` AS `aggregateId`,`aggregate_objectstore_config_mapping`.`objectstoreId` AS `objectstoreId`,`aggregate_objectstore_config_mapping`.`availabilityStateRaw` AS `AvailabilityStatus`,`aggregate_objectstore_config_mapping`.`createTime` AS `createTime` from `netapp_model_view`.`aggregate_objectstore_config_mapping`