View netapp_model_view.storage_shelf_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.
uuid varchar 255 Globally unique ID of the storage shelf. Derived from ShelfUUID. Not from ZAPI
resourceKey varchar 512 DERIVED. A structured key that may be used to uniquely identify this resource globally
clusterId bigint 19
nodeId bigint 19
partnerNodeId varchar 255  √  null Partner Node UUID
shelfUuid varchar 255  √  null Shelf unique identifier that distinguishes it from other shelves manufactured
shelfIdentifier int 10  √  null The shelf id switch setting
sesProductId varchar 255  √  null Enclosure product identifier
firmwareRevisionA varchar 255  √  null Shelf module A firmware revision
firmwareRevisionB varchar 255  √  null Shelf module B firmware revision
module varchar 255  √  null The shelf module attachment
channelName varchar 255  √  null The channel/port-number the shelf (hub) is attached to
shelfType varchar 255  √  null Shelf module type
state enum 13  √  null The current state of the shelf
stateRaw varchar 255  √  null The current state of the shelf - ZAPI raw value
isLocalAttach bit 0  √  null
stackId varchar 255  √  null Adding StackId to storage_shelf
temperatureSensorCount int 10  √  null Count of temperature sensors on this shelf
temperatureSensorFailedCount int 10  √  null Count of failed temperature sensors on this shelf. (temp-sensor-info.temp-sensor-is-error)
coolingElementCount int 10  √  null Count of cooling elements on this shelf
coolingElementFailedCount int 10  √  null Count of failed cooling elements on this shelf. (cooling-element-info.cooling-element-is-error)
powerSupplyCount int 10  √  null Count of power supplies on this shelf
powerSupplyFailedCount int 10  √  null Count of failed power supplies on this shelf (power-supply-info.power-supply-is-error)
currentSensorCount int 10  √  null Count of current sensors on this shelf
currentSensorFailedCount int 10  √  null Current of failed current sensors on this shelf (current-sensor-info.is-sensor-error)
voltageSensorCount int 10  √  null Count of current sensors on this shelf
voltageSensorFailedCount int 10  √  null Current of failed current sensors on this shelf (current-sensor-info.is-sensor-error)
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 `netapp_model`.`storage_shelf`.`objid` AS `objid`,`netapp_model`.`storage_shelf`.`uuid` AS `uuid`,`netapp_model`.`storage_shelf`.`resourceKey` AS `resourceKey`,`netapp_model`.`storage_shelf`.`clusterId` AS `clusterId`,`netapp_model`.`storage_shelf`.`nodeId` AS `nodeId`,`netapp_model`.`storage_shelf`.`partnerNodeId` AS `partnerNodeId`,`netapp_model`.`storage_shelf`.`shelfUuid` AS `shelfUuid`,`netapp_model`.`storage_shelf`.`shelfIdentifier` AS `shelfIdentifier`,`netapp_model`.`storage_shelf`.`sesProductId` AS `sesProductId`,`netapp_model`.`storage_shelf`.`firmwareRevisionA` AS `firmwareRevisionA`,`netapp_model`.`storage_shelf`.`firmwareRevisionB` AS `firmwareRevisionB`,`netapp_model`.`storage_shelf`.`module` AS `module`,`netapp_model`.`storage_shelf`.`channelName` AS `channelName`,`netapp_model`.`storage_shelf`.`shelfType` AS `shelfType`,`netapp_model`.`storage_shelf`.`state` AS `state`,`netapp_model`.`storage_shelf`.`stateRaw` AS `stateRaw`,`netapp_model`.`storage_shelf`.`isLocalAttach` AS `isLocalAttach`,`netapp_model`.`storage_shelf`.`stackId` AS `stackId`,`netapp_model`.`storage_shelf`.`temperatureSensorCount` AS `temperatureSensorCount`,`netapp_model`.`storage_shelf`.`temperatureSensorFailedCount` AS `temperatureSensorFailedCount`,`netapp_model`.`storage_shelf`.`coolingElementCount` AS `coolingElementCount`,`netapp_model`.`storage_shelf`.`coolingElementFailedCount` AS `coolingElementFailedCount`,`netapp_model`.`storage_shelf`.`powerSupplyCount` AS `powerSupplyCount`,`netapp_model`.`storage_shelf`.`powerSupplyFailedCount` AS `powerSupplyFailedCount`,`netapp_model`.`storage_shelf`.`currentSensorCount` AS `currentSensorCount`,`netapp_model`.`storage_shelf`.`currentSensorFailedCount` AS `currentSensorFailedCount`,`netapp_model`.`storage_shelf`.`voltageSensorCount` AS `voltageSensorCount`,`netapp_model`.`storage_shelf`.`voltageSensorFailedCount` AS `voltageSensorFailedCount`,`netapp_model`.`storage_shelf`.`createtime` AS `createTime`,`netapp_model`.`storage_shelf`.`updatetime` AS `updateTime`,`netapp_model`.`storage_shelf`.`objState` AS `objState` from `netapp_model`.`storage_shelf`