1400 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
MAIN_MEASURE The Additional measures based on the
FAVORITE.MAIN_MEASURE
varchar 40
ADDITIONAL_MEASURE The Additional measures based on the
FAVORITE.MAIN_MEASURE
int
TABLE 84 DEFAULT_WIDGET_PREFERENCE
Field Definition Format Size
ID Auto incremented Dashboard Widget Preference ID. int
dashboard_id Foreign Key to DASHBOARD(ID). int
widget_id Foreign Key to DASHBOARD_WIDGET(ID). int
installation_type Indicates the widgets is SAN Only (0) / IP Only (1) /
SAN_IP (2).
int
visible Indicates whether the widget is visible for the user in
the dashboard. 0 - Not Visible, 1 - Visible.
int
“state” State of the widget. Possible values are 0 - Normal, 1
- Maximized, 2 - Collapsed.
int
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
defined but not shown.
int
column_index Column position of the widget. -1 for an out-of-box
widget defined but not shown.
int
TABLE 85 DEPLOYMENT_CONFIGURATION
Field Definition Format Size
ID Unique generated database identifier. serial
NAME Name of the configuration varchar 255
CONFIGURATION_TYPE Indentifies the save configuration type.
1 - Not applicable
1 - Running
2 - Startup
3 - Running & Startup
smallint
DEPLOY_OPTION Identifies the deployment options.
1-Deploy Now
2-Save & Deploy
3-Save deployment only
4-Scheduled
smallint
DEPLOYMENT_HANDLER_ID Foreign Key references
DEPLOYMENT_HANDLER (ID). Identifies
the handler to use for the configuration
int
SCHEDULE_ENABLED 1 indicates that the schedule is applied
to the configuration
smallint
TABLE 83 DEFAULT_FAVORITES (Continued)
Field Definition Format Size