View netapp_model_view.network_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: net-port-get-iter.net-port-info
uuid varchar 255 Globally unique ID of the network port. Not available in ZAPI. Uses {PortName}.{MACAddress}
resourceKey varchar 512
name varchar 255 Textual name
nodeId bigint 19
clusterId bigint 19
macAddress varchar 255  √  null Specifies the MAC address of the port
administrativeSpeed enum 11  √  null Speed setting preferred by the port
administrativeSpeedRaw varchar 255  √  null
operationalSpeed enum 11  √  null Speed setting reported by the port
operationalSpeedRaw varchar 255  √  null
linkStatus enum 10  √  null Specifies the link status of the port
linkStatusRaw varchar 255  √  null
role enum 12  √  null Specifies the role associated with the port
roleRaw varchar 255  √  null
portType enum 10  √  null Specifies the role associated with the port
portTypeRaw varchar 255  √  null
vlanIdentifier bigint 19  √  null For ports of type VLAN, the VLAN ID
vlanPortId bigint 19  √  null ID of the physical port on which the VLAN is created
ifgrpPortId bigint 19  √  null ID of the IFGRP port on which the port belongs
mtu bigint 19  √  null Specifies the maximum transmission unit of the port
operationalDuplex enum 10  √  null Duplex setting reported by the port after Ethernet auto-negotiation
operationalDuplexRaw varchar 255  √  null
networkIpSpaceId bigint 19  √  null IP Space associated with the network port.
networkPortBroadcastDomainId bigint 19  √  null Broadcast domain associated with the network port.
healthStatus enum 11  √  null health status of the network port
healthStatusRaw varchar 64  √  null raw type of the health status
ignoreHealthStatus bit 0  √  null Indicates whether or not to consider health status
healthDegradedReasons enum 15  √  null health degraded reasons of the network port
healthDegradedReasonsRaw varchar 64  √  null raw type of health degraded reasons
isAdministrativeUp bit 0  √  null If true, it changes the state of the port to 'up'.
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 `np`.`objid` AS `objid`,`np`.`uuid` AS `uuid`,`np`.`resourceKey` AS `resourceKey`,`np`.`name` AS `name`,`np`.`nodeId` AS `nodeId`,`np`.`clusterId` AS `clusterId`,`np`.`macAddress` AS `macAddress`,`np`.`administrativeSpeed` AS `administrativeSpeed`,`np`.`administrativeSpeedRaw` AS `administrativeSpeedRaw`,`np`.`operationalSpeed` AS `operationalSpeed`,`np`.`operationalSpeedRaw` AS `operationalSpeedRaw`,`np`.`linkStatus` AS `linkStatus`,`np`.`linkStatusRaw` AS `linkStatusRaw`,`np`.`role` AS `role`,`np`.`roleRaw` AS `roleRaw`,`np`.`portType` AS `portType`,`np`.`portTypeRaw` AS `portTypeRaw`,`np`.`vlanIdentifier` AS `vlanIdentifier`,`netapp_model`.`network_port_relationship`.`vlanPortId` AS `vlanPortId`,`netapp_model`.`network_port_relationship`.`ifgrpPortId` AS `ifgrpPortId`,`np`.`mtu` AS `mtu`,`np`.`operationalDuplex` AS `operationalDuplex`,`np`.`operationalDuplexRaw` AS `operationalDuplexRaw`,`np`.`networkIpSpaceId` AS `networkIpSpaceId`,`np`.`networkPortBroadcastDomainId` AS `networkPortBroadcastDomainId`,`np`.`healthStatus` AS `healthStatus`,`np`.`healthStatusRaw` AS `healthStatusRaw`,`np`.`ignoreHealthStatus` AS `ignoreHealthStatus`,`np`.`healthDegradedReasons` AS `healthDegradedReasons`,`np`.`healthDegradedReasonsRaw` AS `healthDegradedReasonsRaw`,`np`.`isAdministrativeUp` AS `isAdministrativeUp`,`np`.`createtime` AS `createTime`,`np`.`updatetime` AS `updateTime`,`np`.`objState` AS `objState` from (`netapp_model`.`network_port` `np` left join `netapp_model`.`network_port_relationship` on((`np`.`objid` = `netapp_model`.`network_port_relationship`.`objid`)))