Brocade Communications Systems IP250 Vrconnserverprofile, Vrconnwwn, Wirelessproductdetails

	Database tables and fields		I
TABLE 500 VR_CONN_SERVER_PROFILE
Field	Definition	Format	Size
ID	Unique generated database identifier.	serial
VCEM_PROFILE_ID	Foreign key references the ID of the VCEM	int
	server that the server profile belongs to.
VR_CONN_DOMAIN_GROUP_I	Nullable foreign key references the ID of the	int
D	domain group that the server profile may
	belong to.
VCEM_ASSIGNED_ID	The ID assigned by the VCEM server.	bigint
NAME		varchar	256
BAY_NAME		varchar	256
BAY_NUMBER		smallint
VIRTUAL_SERIAL_NUMBER		varchar	32
CREATION_TIME		timestamp
LAST_UPDATE_TIME		timestamp
BAY_ENCLOSURE_UUID	The UUID extracted from the enclosure	varchar	512
	object inside the bay object inside the
	server profile. The value matches the
	domain GUID.

TABLE 501 VR_CONN_WWN

Field	Definition	Format	Size
ID	Unique generated database identifier.	int
VR_CONN_FC_CONNECTION_ID	Foreign key references the ID of the FC	int
	connection that the WWN belongs to
PORT_ADDRESS	Port WWN	char	23
NODE_ADDRESS	Node WWN	char	23
SAN_NAME		varchar	256
CREATION_TIME		timestamp
LAST_UPDATE_TIME		timestamp

TABLE 502 WIRELESS_PRODUCT_DETAILS

Field	Definition	Format	Size
ID	The primary key of the table.	int
DEVICE_ID	Each AP or Controller has an entry in the	int
	table. No other device will have entries
	here. The foreign key reference to device
	table.
CONTROLLER_DEVICE_ID	The reference to the APs controller in	int
	device table. If APs controller gets deleted,
	the value sets to null. If the entry is
	controller the value is null.
PROFILE_NAME	Profile name that the AP is using.	varchar	64

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