Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1163
53-1002696-01
Database tables and fields
H
TABLE 40 CED_APPLICATION_MEMBER
Field Definition Format Size
APPLICATION_ID* Auto-generated DB CED_Application table ID. int
ZONE_ID* Auto-generated DB Zone table ID which joins as a
member of the application.
int
TABLE 41 CED_USER_PREFERENCE
Field Definition Format Size
USER_NAME* User Name carried from _USER table. varchar 128
FABRIC_ID* Fabric ID carried from Fabric table. int
APPLICATION_ID CED application ID representing the group of end
devices to be displayed in the fabric.
int
TABLE 42 CEE_PORT
Field Definition Format Size
ID Unique generated database identifier. int
GIGE_PORT_ID FK to GIGE_PORT int
VIRTUAL_SWITCH_ID FK to owning VIRTUAL_SWITCH int
IF_INDEX Interface index int
IF_NAME Interface name varchar 256
IF_MODE Gige port mode (L2, L3, none) varchar 8
L2_MODE L2 mode (hybrid, trunk, access) varchar 32
VLAN_ID List of VLAN this port belongs to text
LAG_ID LAG ID this port belongs to int
IP_ADDRESS Port''s configured IP address varchar 128
MAC_ADDRESS Port''s MAC address varchar 64
PORT_SPEED Speed in Gb/sec. The default value is 0. int
ENABLED State. The default value is 0. smallint
OCCUPIED The default value is 0. smallint
LAST_UPDATE bigint
MAC_ACL_POLICY stores the MAC ACL policy information of the port varchar 64
NET_MASK Netmask of the IPAddress of the port varchar 128
PROTOCOL_DOWN_REAS
ON
Reason for the port''s operational state being down varchar 512
QOS_TYPE QoS Type (Cee-Map, TrafficClass Map, FCoE map) varchar 32
QOS_NAME Name of the QoS Map set on the port varchar 64