Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1770)

1718 Brocade Network Advisor SAN User Manual
53-1003154-01
Database tables and fields
H
TABLE 439 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 440 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 441 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 442 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 443 USER_ROLE_MAP
Field Definition Format Size
USER_NAME* User name. varchar 128
ROLE_ID* Role ID, which is mapped for the user. int