Brocade Communications Systems IP250 Database tables and fields Physicaldevice, Physicalinterface

I Database tables and fields

TABLE 272 PHYSICAL_DEVICE (Continued)

Field	Definition	Format	Size
UNIT_NEIGHBOR1	Stacking neighbor's unit(left) number for the	num	(2,0)
	stackable devices. If there is no neighbor unit/non
	stackable devices, then set to 0.
UNIT_NEIGHBOR2	Stacking neighbor's unit(left) number for the	num	(2,0)
	stackable devices . If there is no neighbor unit/non
	stackable devices, then set to 0.
UNIT_PRESENT	Used to identify the stack unit is present in the	num	(1,0)
	chassis or not. Present-1 and Not Present-2.

TABLE 273 PHYSICAL_INTERFACE

Field	Definition	Format	Size
INTERFACE_ID	Primary key for this table.	int
PHYSICAL_PORT_ID	Foreign key which refers PHYSICAL_PORT table.	int
SPEED_IN_MB	Interface speed in Mega Bytes.	int
PHYSICAL_ADDRESS	MAC address of this interface.	varchar	64
LINK_ID	Foreign key which refers LINK table.	int
DUPLEX_MODE	Interface duplex mode. Full/Half/Auto.	smallint
IS_STACKING_INTERFACE	This flag is to indicate whether the interface is	num	(1,0)
	stacking interface or peri port. 0 indicates
	non-stacking, 1-indicates stacking interface,
	2-indicates peri port.
IS_PORT_PRESENT	This flag is to indicate whether the port is presented	int
	in the device.
	0 = Unknown
	1 = Present
	2 = Not present
PHYSICAL_DEVICE_ID	For DCB switch, this is the core switch id.	int
	For IP products, this is the physical_device_id in
	physical_device table.
UNIT_NUMBER	This is the unit number of which the interface is	int
	located for IP stacking products.
	If it is not applicable, the value is -1.
SLOT_NUMBER	This is the slot number of which the interface is	int
	located for the devices and switches.
	If it is not applicable, the value is -1.
PORT_NUMBER	This is the port number of the interface.	int
PORT_TYPE	This column is used to store the port type of the	smallint
	interface. The value will be populated by the
	NosSwitchAssetCollector during the discovery of the
	VCS switch.The value of 0 means its edge port, and 1
	means its trill port. Default value is 0.
UNIT_TYPE	Indicates unit type in the stack. This column stores	varchar	64
	the model type of a stackable unit such as
	"ICX6610-48P". For non-stacking device it will be
	empty

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