Brocade Communications Systems Network Advisor 12.0.0, User Manual

Page: 1370 / 1505

1322 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
TABLE 367 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 368 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 369
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 370
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 371 V_PORT_DETAIL
Field Definition Format Size
DEVICE_PORT_ID Primary key from the owner device port table. int
STATE Flag to indicate whether port is online or offline varchar 32
FCP_INITIATOR The role of the virtual port; for example, FCP Initiator varchar 256
SWITCH_IP IP of the switch, the V port is connected to varchar 128
VF_ID VF ID for the V port smallint