View netapp_model_view.storage_adapter 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: storage-adapter-get-adapter-list.adapter-list.adapter-name-elem, storage-adapter-get-adapter-info.adapter-details.adapter-detail-info
uuid varchar 255 Globally unique ID of the adapter. Not from ZAPI. Format is {NodeUUID.{adapterName}
resourceKey varchar 512
clusterId bigint 19
nodeId bigint 19
name varchar 255  √  null Name of the adapter
fcNodeName varchar 255  √  null FCP World Wide Node Name (WWNN) of the adapter. Only for FC type adapters
isInUse bit 0  √  null Is the adapter inuse? Only for FC type adapters
model varchar 255  √  null Model of the adapter. Only for FC type adapters
fcLinkRate int 10  √  null The maximum speed/rate of this adapter in Gbit/sec.
status enum 10  √  null Status of the adapter
adapterType enum 20  √  null Type of adapter present in the system
fcPortName varchar 255  √  null Fibre Channel World Wide Port Name (WWPN) of adapter.
state enum 16  √  null Current state of the adapter
stateRaw varchar 255  √  null Raw value of Current state of the adapter
cableEndIdentifier varchar 255  √  null Each cable has two ends. This field shows which end of the cable is connected to the shelf.
cableLength varchar 255  √  null Cable Length.
cableManufacturer varchar 255  √  null Manufacturer of the cable.
cablePartNumber varchar 255  √  null Part number of the cable as assigned by the cable manufacturer.
cableSerialNumber varchar 255  √  null Cable identifier. For backwards compatibility this is reported as cable-serial-number.
attachedSerialNumber varchar 255  √  null Serial number of the attached cable as assigned by the cable manufacturer.
cableTechnology varchar 255  √  null Cable Technology.
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`storage_adapter`.`objid` AS `objid`,`netapp_model`.`storage_adapter`.`uuid` AS `uuid`,`netapp_model`.`storage_adapter`.`resourceKey` AS `resourceKey`,`netapp_model`.`storage_adapter`.`clusterId` AS `clusterId`,`netapp_model`.`storage_adapter`.`nodeId` AS `nodeId`,`netapp_model`.`storage_adapter`.`name` AS `name`,`netapp_model`.`storage_adapter`.`fcNodeName` AS `fcNodeName`,`netapp_model`.`storage_adapter`.`isInUse` AS `isInUse`,`netapp_model`.`storage_adapter`.`model` AS `model`,`netapp_model`.`storage_adapter`.`fcLinkRate` AS `fcLinkRate`,`netapp_model`.`storage_adapter`.`status` AS `status`,`netapp_model`.`storage_adapter`.`adapterType` AS `adapterType`,`netapp_model`.`storage_adapter`.`fcPortName` AS `fcPortName`,`netapp_model`.`storage_adapter`.`state` AS `state`,`netapp_model`.`storage_adapter`.`stateRaw` AS `stateRaw`,`netapp_model`.`storage_adapter`.`cableEndIdentifier` AS `cableEndIdentifier`,`netapp_model`.`storage_adapter`.`cableLength` AS `cableLength`,`netapp_model`.`storage_adapter`.`cableManufacturer` AS `cableManufacturer`,`netapp_model`.`storage_adapter`.`cablePartNumber` AS `cablePartNumber`,`netapp_model`.`storage_adapter`.`cableSerialNumber` AS `cableSerialNumber`,`netapp_model`.`storage_adapter`.`attachedSerialNumber` AS `attachedSerialNumber`,`netapp_model`.`storage_adapter`.`cableTechnology` AS `cableTechnology`,`netapp_model`.`storage_adapter`.`createtime` AS `createTime`,`netapp_model`.`storage_adapter`.`updatetime` AS `updateTime` from `netapp_model`.`storage_adapter` where (`netapp_model`.`storage_adapter`.`objState` = 'LIVE')