Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1598

Advertising
background image

1546

Brocade Network Advisor SAN User Manual

53-1003154-01

Database tables and fields

H

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

Advertising