Brocade Network Advisor SAN User Manual v12.1.0 - Manual (Page 1544)

Brocade Network Advisor SAN User Manual 1497
53-1002948-01
Database tables and fields
H
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 375 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 376 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
MIB_OBJECT_ID This is the foreign key reference key to the
mib_object Table int
TYPE This identifies the collectible type. 0 for MIBs, 1 for
Expressions int
TABLE 377 USER_RESOURCE_MAP
Field Definition Format Size
USER_NAME* User name. varchar 128
RESOURCE_GROUP_ID* Resource group name, which is mapped for the user. int
TABLE 378 USER_ROLE_MAP
Field Definition Format Size
USER_NAME* User name. varchar 128
ROLE_ID* Role ID, which is mapped for the user. int
TABLE 374 USERDEFINED_NETWORK_SCOPE_MEMBERSHIP
Field Definition Format Size