View netapp_model_view.fcp_port_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. 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
resourceKey varchar 512
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 enum 10  √  null Speed configured for this adapter
speedRaw varchar 255  √  null
physicalProtocol enum 14  √  null The physical protocol of the adapter.
physicalProtocolRaw varchar 255  √  null
state enum 26  √  null Status of the adapter.
stateRaw varchar 255  √  null
status enum 10  √  null Status of the port.
statusRaw 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 enum 10  √  null Media configured for this adapter
mediaTypeRaw varchar 255  √  null
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state
statusAdmin enum 10  √  null Administrative status of the port
statusAdminRaw varchar 10  √  null Administrative status (raw value) of the port

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`fcp_port`.`objid` AS `objid`,`netapp_model`.`fcp_port`.`uuid` AS `uuid`,`netapp_model`.`fcp_port`.`resourceKey` AS `resourceKey`,`netapp_model`.`fcp_port`.`clusterId` AS `clusterId`,`netapp_model`.`fcp_port`.`nodeId` AS `nodeId`,`netapp_model`.`fcp_port`.`nodeName` AS `nodeName`,`netapp_model`.`fcp_port`.`portName` AS `portName`,`netapp_model`.`fcp_port`.`adapter` AS `adapter`,`netapp_model`.`fcp_port`.`fabricEstablished` AS `fabricEstablished`,`netapp_model`.`fcp_port`.`firmwareRev` AS `firmwareRev`,`netapp_model`.`fcp_port`.`infoName` AS `infoName`,`netapp_model`.`fcp_port`.`maxSpeed` AS `maxSpeed`,`netapp_model`.`fcp_port`.`speed` AS `speed`,`netapp_model`.`fcp_port`.`SpeedRaw` AS `speedRaw`,`netapp_model`.`fcp_port`.`physicalProtocol` AS `physicalProtocol`,`netapp_model`.`fcp_port`.`PhysicalProtocolRaw` AS `physicalProtocolRaw`,`netapp_model`.`fcp_port`.`state` AS `state`,`netapp_model`.`fcp_port`.`StateRaw` AS `stateRaw`,`netapp_model`.`fcp_port`.`status` AS `status`,`netapp_model`.`fcp_port`.`StatusRaw` AS `statusRaw`,`netapp_model`.`fcp_port`.`switchPort` AS `switchPort`,`netapp_model`.`fcp_port`.`dataLinkRate` AS `dataLinkRate`,`netapp_model`.`fcp_port`.`mediaType` AS `mediaType`,`netapp_model`.`fcp_port`.`MediaTypeRaw` AS `mediaTypeRaw`,`netapp_model`.`fcp_port`.`createtime` AS `createTime`,`netapp_model`.`fcp_port`.`updatetime` AS `updateTime`,`netapp_model`.`fcp_port`.`objState` AS `objState`,`netapp_model`.`fcp_port`.`statusAdmin` AS `statusAdmin`,`netapp_model`.`fcp_port`.`statusAdminRaw` AS `statusAdminRaw` from `netapp_model`.`fcp_port`