User's Manual

1562 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
FABRIC_ID Foreign Key FABRIC.ID. The ID of the fabric in the
membership. This can be null if user does not include
Fabric in his custom membership.
int
PRODUCT_ME_ID Foreign Key MANAGED_ELEMENT.ID. The ME ID of the
device in the membership. This can be null if user does
not include Switch in his custom membership.
int
SWITCH_PORT_ID Foreign Key SWITCH_PORT.ID. The ID of the switch Port
in the membership. This can be null if user does not
include Switch Port in his custom membership.
int
INTERFACE_ID Foreign Key INTERFACE. INTERFACE_ID. The ID of the
Interface in the membership. This can be null if user
does not include Interface in his custom membership.
int
DEVICE_PORT_ID Foreign Key DEVICE_PORT.ID. The ID of the Device Port
in the membership. This can be null if user does not
include Device Port in his custom membership.
int
TABLE 429 USER_PREFERENCE
Field Definition Format Size
USER_NAME * User name whose preferences are saved. It corresponds
to user_name in USER_table.
varchar 128
CATEGORY * The name for a set of related preferences. varchar 128
CONTENT The set of preferences saved as name-value pairs. text
TABLE 430 USER_REALTIME_MEASURE_MAPPING
Field Definition Format Size
ID Primary Key. int
USER_ID Foreign key reference to the user_ Table. int
EXPRESSION_ID Foreign key reference to Measure Table. int
MIB_OBJECT_ID Foreign key reference to Measure Table. int
MEASURE_TYPE This identifies the collectible type. 0 for MIBs and 1
for Expressions.
int
TABLE 431 USER_REALTIME_MEASURE_SETTING
Field Definition Format Size
ID Primary Key field for the
user_realtime_measure_setting table
int
USER_ID This is the foreign key reference key to the user_
Table
int
EXPRESSION_ID This is the foreign key reference key to the
snmp_expression Table
int
TABLE 428 USERDEFINED_NETWORK_SCOPE_MEMBERSHIP
Field Definition Format Size