Brocade Network Advisor IP User Manual v12.3.0 - Manual (Page 1608)

1556 Brocade Network Advisor IP User Manual
53-1003153-01
Database tables and fields
I
TABLE 100 DEVICE_GROUP_ENTRY
Field Definition Format Size
DEVICE_GROUP_ID Database ID of the DEVICE_GROUP instance which
the device is member of. int
DEVICE_GROUP_ENTRY_ID Unique database auto generated identifier. int
DEVICE_ID Database ID of the member DEVICE. int
TABLE 101 DEVICE_GROUP
Field Definition Format Size
DEVICE_GROUP_ID Primary key for this table. int
NAME Name of this device group. varchar 128
USER_ID User ID corresponds to the user who created the
device. int
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 102 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 103 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