View ocum_report.networkport 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: net-port-get-iter.net-port-info
uuid varchar 255 Globally unique ID of the network port. Not available in ZAPI. Uses {PortName}.{MACAddress}
name varchar 255 Textual name
clusterId bigint 19
nodeId bigint 19
macAddress varchar 255  √  null Specifies the MAC address of the port
administrativeSpeed varchar 255  √  null
operationalSpeed varchar 255  √  null
linkStatus varchar 255  √  null
role varchar 255  √  null
portType varchar 255  √  null
vlanIdentifier bigint 19  √  null For ports of type VLAN, the VLAN ID
mtu bigint 19  √  null Specifies the maximum transmission unit of the port
operationalDuplex varchar 255  √  null

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `network_port`.`objid` AS `id`,`network_port`.`uuid` AS `uuid`,`network_port`.`name` AS `name`,`network_port`.`clusterId` AS `clusterId`,`network_port`.`nodeId` AS `nodeId`,`network_port`.`macAddress` AS `macAddress`,`network_port`.`administrativeSpeedRaw` AS `administrativeSpeed`,`network_port`.`operationalSpeedRaw` AS `operationalSpeed`,`network_port`.`linkStatusRaw` AS `linkStatus`,`network_port`.`roleRaw` AS `role`,`network_port`.`portTypeRaw` AS `portType`,`network_port`.`vlanIdentifier` AS `vlanIdentifier`,`network_port`.`mtu` AS `mtu`,`network_port`.`operationalDuplexRaw` AS `operationalDuplex` from `netapp_model_view`.`network_port`