Brocade Communications Systems IP250 Database tables and fields Devicegroup, Devicenode

			Database tables and fields		I
TABLE 98	DEVICE_GROUP (Continued)
Field		Definition		Format	Size
DESCRIPTION		Device group description.		varchar	255
IS_PUBLIC		Flag to identify whether this group is shared across		num	(1,0)
		users.
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		num	(1,0)
		device group.
IS_SENSOR_GROUP		Flag to identify whether this group is sensor device		num	(1,0)
		group.
VIEW_MASK		Flag to decide whether to show the device group in		num	(1,0)
		topology or not.
GROUP_TYPE		This flag is to classify the device group type:		int
		• 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
TABLE 99	DEVICE_MAC_GROUP_MAPPING
Field		Definition		Format	Size
MAC_GROUP_DB_ID		Foreign Key Reference to the MAC_GROUP table. Part		int
		of Primary key.
DEVICE_ID		Foreign Key reference to DEVICE table. Part of		int
		Primary key;
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		varchar	32
		values are Initiator, Target, Initiator+Target,
		Unknown(Initiator or Target)
DEVICE_TYPE		0 = physical		smallint
		1 = virtual
		2 = NPV
		3 = iSCSI
		4 = both physical & virtual
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

Brocade Network Advisor IP User Manual	1413
53-1003056-01