User's Manual

Brocade Network Advisor IP User Manual 1413
53-1003056-01
Database tables and fields
I
DESCRIPTION Device group description. varchar 255
IS_PUBLIC Flag to identify whether this group is shared across
users.
num (1,0)
IS_INTERNAL Flag to identify this group is internal. num (1,0)
TABLE_SUBTYPE Table subtype defined by BizObject framework varchar 32
IS_AP_GROUP Flag to identify whether this group is access point
device group.
num (1,0)
IS_SENSOR_GROUP Flag to identify whether this group is sensor device
group.
num (1,0)
VIEW_MASK Flag to decide whether to show the device group in
topology or not.
num (1,0)
GROUP_TYPE This flag is to classify the device group type:
• 0 is the default and reserved for internal
temporary group
• 1 is for System Device Group
• 2 is for MPLS System Device Group
• 3 is for User Defined Device Group
int
TABLE 99 DEVICE_MAC_GROUP_MAPPING
Field Definition Format Size
MAC_GROUP_DB_ID Foreign Key Reference to the MAC_GROUP table. Part
of Primary key.
int
DEVICE_ID Foreign Key reference to DEVICE table. Part of
Primary key;
int
TABLE 100 DEVICE_NODE
Field Definition Format Size
ID* Unique generated database identifier. int
FABRIC_ID Fabric DB ID to which this device node belongs. int
WWN Device node WWN. char 23
TYPE Initiator or target or both or unknown. The possible
values are Initiator, Target, Initiator+Target,
Unknown(Initiator or Target)
varchar 32
DEVICE_TYPE 0 = physical
1 = virtual
2 = NPV
3 = iSCSI
4 = both physical & virtual
smallint
SYMBOLIC_NAME Device node symbolic name. varchar 256
FDMI_HOST_NAME Device node FDMI host name. varchar 128
VENDOR Device node vendor. varchar 64
CAPABILITY_ varchar 16
TABLE 98 DEVICE_GROUP (Continued)
Field Definition Format Size