View ocum_report.fcpport 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. ZAPIs: fcp-adapter-get-iter.fcp-config-adapter-info
uuid varchar 255 Globally unique ID of the fcp port. Not available in ZAPI. Uses fcp-config-adapter-info.port-name
clusterId bigint 19
nodeId bigint 19
nodeName varchar 255  √  null FCP World Wide Node Name (WWNN) of the adapter.
portName varchar 255  √  null FCP World Wide Port Name (WWPN) of adapter.
adapter varchar 255  √  null The slot name of the FC adapter.
fabricEstablished bit 0  √  null 1 if fabric is established to this adapter, 0 otherwise.
firmwareRev varchar 255  √  null Firmware revision of adapter.
infoName varchar 255  √  null Info name given to this adapter.
maxSpeed int 10  √  null The maximum speed of this adapter in Gbit/sec.
speed varchar 255  √  null
physicalProtocol varchar 255  √  null
state varchar 255  √  null
status varchar 255  √  null
switchPort varchar 255  √  null Switch and port this adapter is connected to. The string will be of the form X:Y where X is the name of the switch and Y is the port value.
dataLinkRate int 10  √  null Data link rate in Gbits
mediaType varchar 255  √  null

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `fcp_port`.`objid` AS `id`,`fcp_port`.`uuid` AS `uuid`,`fcp_port`.`clusterId` AS `clusterId`,`fcp_port`.`nodeId` AS `nodeId`,`fcp_port`.`nodeName` AS `nodeName`,`fcp_port`.`portName` AS `portName`,`fcp_port`.`adapter` AS `adapter`,`fcp_port`.`fabricEstablished` AS `fabricEstablished`,`fcp_port`.`firmwareRev` AS `firmwareRev`,`fcp_port`.`infoName` AS `infoName`,`fcp_port`.`maxSpeed` AS `maxSpeed`,`fcp_port`.`speedRaw` AS `speed`,`fcp_port`.`physicalProtocolRaw` AS `physicalProtocol`,`fcp_port`.`stateRaw` AS `state`,`fcp_port`.`statusRaw` AS `status`,`fcp_port`.`switchPort` AS `switchPort`,`fcp_port`.`dataLinkRate` AS `dataLinkRate`,`fcp_port`.`mediaTypeRaw` AS `mediaType` from `netapp_model_view`.`fcp_port`