Brocade Communications Systems IP250 Database tables and fields Dashboardwidget, Defaultfavorites

		Database tables and fields			I
TABLE 81	DASHBOARD_WIDGET (Continued)
Field		Definition	Format		Size
installation_type		Indicates the widgets is SAN Only (0) / IP Only	int
		(1) / SAN_IP (2)'
shared_provider		Can the provider be shared? 0 - Not Shared 1	int
		- Shared.
TABLE 82	DASHBOARD_WIDGET_PREFERENCE
Field		Definition		Format	Size
ID		Auto incremented widget preference ID.		int
WIDGET_ID		Foreign Key to DASHBOARD_WIDGET(ID).		int
USER_ID		Foreign Key to USER_ (ID).		int
DASHBOARD_ID		Foreign Key to DASHBOARD(ID).		int
VISIBLE		Indicates whether the widget is visible for the user in		smallint
		the dashboard. 0 - Not Visible, 1 - Visible.
STATE		State of the widget. Possible values are 0 - Normal, 1		int
		- Maximized, 2 - Collapsed.
WIDTH		Width of the widget.		int
HEIGHT		Height of the widget.		int
ROW_INDEX		Row position of the widget. -1 for an out-of-box widget		int
		defined but not shown.
COLUMN_INDEX		Column position of the widget. -1 for an out-of-box		int
		widget defined but not shown.
CANVAS_ID		Foreign Key to DASHBOARD_CANVAS.ID		int
TABLE 83	DEFAULT_FAVORITES
Field		Definition		Format	Size
ID		Name of the favorite.		int
NAME		The topnumber of ports (5,10,15,20).		varchar	64
TOP_N		Types of ports (FC/FCIP/GE) and -End Monitors.		varchar	40
SELECTION_FILTER		The time interval in which the graph is shown.		varchar	40
FROM_TIME		Always null. The default favorite is not customized.		varchar	40
CUSTOM_LAST_VALUE		Always null. The default favorite is not customized.		int
CUSTOM_TIME_UNIT		Always null. The default favorite is not customized.		varchar	40
CUSTOM_FROM		Always null. The default favorite is not customized.		timestamp
CUSTOM_TO		The default five minutes granularity.		timestamp
GRANULARITY		Always null.		varchar	40
THRESHOLD		The measure Tx MBps or Rx MBps based on		int
		DEFAULT_FAVORITES.NAME

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