View netapp_model_view.storage_shelf_cable_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 Application Record. Equal to {ClusterUUID}.{ShelfId}.{ChannelName}.{PartNumber}.{SerialNumber}.{ConnectorNumber}. Not returned 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
shelfId bigint 19
channelName varchar 255 Storage controller channel the shelf is connected to.
isShelfChannelFailure bit 0  √  null Indicates whether any shelves on this channel have experienced a failure.
endIdentifier varchar 255  √  null Each cable has two ends. This field shows which end of the cable is connected to the shelf.
length varchar 255  √  null Cable length
manufacturer varchar 255  √  null Manufacturer of the cable.
partNumber varchar 255  √  null Part number of the cable as assigned by the cable manufacturer.
serialNumber varchar 255  √  null Cable identifier. For backwards compatibility this is reported as cable-serial-no.
attachedSerialNumber varchar 255  √  null Serial number of the attached cable as assigned by the cable manufacturer.
technology varchar 255  √  null Cable Technology.
type varchar 255  √  null Type of the cable being used
connectorDesignator varchar 255  √  null Connector Designator
connectorNumber int 10  √  null Connector Number
isCableConnected bit 0  √  null Indicates whether a cable is connected at this connector location. No further information will be provided if a cable is not connected at this connector location. Note that a cable connection does not necessarily mean that the shelf is connected to a storage controller. This will also depend on the other end of the cable.
isConnectorError bit 0  √  null Indicates whether the connector element has encountered an error.
swapCount int 10  √  null Number of times, since last boot, a cable has been inserted into this connector
shelfModule varchar 255  √  null Shelf module for this connector.
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_cable`.`objid` AS `objid`,`netapp_model`.`storage_shelf_cable`.`UUID` AS `uuid`,`netapp_model`.`storage_shelf_cable`.`resourceKey` AS `resourceKey`,`netapp_model`.`storage_shelf_cable`.`clusterId` AS `clusterId`,`netapp_model`.`storage_shelf_cable`.`nodeId` AS `nodeId`,`netapp_model`.`storage_shelf_cable`.`shelfId` AS `shelfId`,`netapp_model`.`storage_shelf_cable`.`channelName` AS `channelName`,`netapp_model`.`storage_shelf_cable`.`isShelfChannelFailure` AS `isShelfChannelFailure`,`netapp_model`.`storage_shelf_cable`.`endIdentifier` AS `endIdentifier`,`netapp_model`.`storage_shelf_cable`.`length` AS `length`,`netapp_model`.`storage_shelf_cable`.`manufacturer` AS `manufacturer`,`netapp_model`.`storage_shelf_cable`.`partNumber` AS `partNumber`,`netapp_model`.`storage_shelf_cable`.`serialNumber` AS `serialNumber`,`netapp_model`.`storage_shelf_cable`.`attachedSerialNumber` AS `attachedSerialNumber`,`netapp_model`.`storage_shelf_cable`.`technology` AS `technology`,`netapp_model`.`storage_shelf_cable`.`type` AS `type`,`netapp_model`.`storage_shelf_cable`.`connectorDesignator` AS `connectorDesignator`,`netapp_model`.`storage_shelf_cable`.`connectorNumber` AS `connectorNumber`,`netapp_model`.`storage_shelf_cable`.`isCableConnected` AS `isCableConnected`,`netapp_model`.`storage_shelf_cable`.`isConnectorError` AS `isConnectorError`,`netapp_model`.`storage_shelf_cable`.`swapCount` AS `swapCount`,`netapp_model`.`storage_shelf_cable`.`shelfModule` AS `shelfModule`,`netapp_model`.`storage_shelf_cable`.`createtime` AS `createTime`,`netapp_model`.`storage_shelf_cable`.`updatetime` AS `updateTime`,`netapp_model`.`storage_shelf_cable`.`objState` AS `objState` from `netapp_model`.`storage_shelf_cable`