Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1485)

Brocade Network Advisor IP User Manual 1431
53-1002947-01
Database tables and fields
I
CREATION_TIME Time when dashboard was created. timestamp
LAST_OPENED_TIME Time when dashboard was last opened. timestamp
TABLE 152 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 153 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 154 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 151 DASHBOARD (Continued)
Field Definition Format Size