Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1476 Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
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 396 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 397 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 398 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 399 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 395 USERDEFINED_NETWORK_SCOPE_MEMBERSHIP
Field Definition Format Size