Brocade Network Advisor SAN + IP User Manual v12.3.0 - Manual (Page 2358)

2286 Brocade Network Advisor SAN + IP User Manual
53-1003155-01
Database tables and fields
I
LAST_OPENED_TIME Time when dashboard was last opened. timestamp
SHARED Indicates whether the dashboard is shared. 0 -
Not Shared 1 - Shared. int
TABLE 81 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 82 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 83 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 80 DASHBOARD (Continued)
Field Definition Format Size