1560 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
TABLE 42 3 TRUNK_GROUP_MEMBER
Field Definition Format Size
TRUNK_GROUP_MEMBER_I
D
Primary key for this table. int
INTERFACE_ID Foreign key which refers INTERACE table. int
TRUNK_INTERFACE_ID Foreign key which refers TRUNK_GROUP_INTERACE
table.
int
LAG_NAME Lag name of the trunk. varchar 64
TABLE 424 USER_
Field Definition Format Size
ID * Unique generated database identifier. int
NAME User name. varchar 128
DESCRIPTION User description. varchar 512
PASSWORD User password. varchar 512
EMAIL User e-mail ID. varchar 1024
NOTIFICATION_ENABLED Flag for e-mail notification.
Default value is 0.
smallint
FULL_NAME User’'s Full Name. varchar 512
PHONE_NUMBER User’'s Phone number. varchar 32
INVALID_LOGIN_COUNT This is a counter filed to identify the number of invalid
login attempts.
NOTE: After successful login this filed will be set to
NULL.
Default value is 0.
smallint
LOCKED_OUT_DATETIME The date time stamp when a user got locked out
because of exceeding max number of invalid login
attempts.
timestamp
STATUS User’s account status:
0=Disabled
1=Enabled
Default value is 1.
smallint
SOURCE_OF_CREATION To identify the source for creating the user account.
0= User created through Management
application Client
1= User created when authenticated through
external server.
NOTE: At present there is no direct use of this field
however this can be referred in future to build
certain reports.
Default value is 0.
smallint
IP_PRODUCT_LOGIN_NAME User CLI credential login user name. varchar 256
IP_PRODUCT_LOGIN_PASS
WORD
User CLI credential login password. varchar 768