Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1351
53-1002948-01
Database tables and fields
H
CREATION_TIME Time when dashboard was created. timestamp
LAST_OPENED_TIME Time when dashboard was last opened. timestamp
TABLE 137 DASHBOARD_CANVAS
Field Definition Format Size
ID Dashboard Canvas ID. int
NAME Name of the Dashboard canvas. varchar 128
DESCRIPTION Description of the dashboard canvas. varchar 512
TABLE 138 DASHBOARD_CANVAS_PREFERENCE
Field Definition Format Size
ID Dashboard preferences like user ID, Scope ID
etc are stored per dashboard.
int
USER_ID FK USER_.ID. ID of the user who own the
dashboard.
int
SCOPE_ID FK USERDEFINED_NETWORK_SCOPE.ID. This
value will be populated when user selects the
predefined scope.
int
SCOPE_TYPE FK SCOPE_TYPE.ID. This value will be
populated when user select user defined
network scope.
int
DASHBOARD_ID FK DASHBOARD.ID. The ID of the dashboard to
which the preference is applied.
int
DASHBOARD_CANVAS_I
D
FK DASHBOARD_CANVAS.ID. The ID of the
Canvas in which the dashboard is shown
int
VISIBLE Visibility of the dashboard. 0 - Not Visible 1 -
Visible.
smallint
TIME_SCOPE Time Scope of the Dashboard. int
TABLE 139 DASHBOARD_PROVIDER
Field Definition Format Size
CLASS_NAME The fully defined class name of the Provider
class. This is stored per widget Provider
class.
varchar 128
REFRESH_INTERVAL Refresh Interval of the Widget in seconds.
Default is 5 seconds.
int
TABLE 136 DASHBOARD (Continued)
Field Definition Format Size