Database tables and fields

I

 

TABLE 77

DASHBOARD (Continued)

 

 

 

 

 

 

 

 

 

Field

 

Definition

Format

Size

 

 

 

 

 

 

CREATION_TIME

Time when dashboard was created.

timestamp

 

 

 

 

 

 

 

LAST_OPENED_TIME

Time when dashboard was last opened.

timestamp

 

 

 

 

 

 

 

TABLE 78

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 79

DASHBOARD_CANVAS_PREFERENCE

 

 

 

 

 

 

 

 

 

Field

 

Definition

Format

Size

 

 

 

 

 

 

 

ID

 

Dashboard preferences like user ID, Scope ID

int

 

 

 

 

etc are stored per dashboard.

 

 

 

 

 

 

 

 

 

USER_ID

 

FK USER_.ID. ID of the user who own the

int

 

 

 

 

dashboard.

 

 

 

 

 

 

 

 

 

SCOPE_ID

 

FK USERDEFINED_NETWORK_SCOPE.ID. This

int

 

 

 

 

value will be populated when user selects the

 

 

 

 

 

predefined scope.

 

 

 

 

 

 

 

 

 

SCOPE_TYPE

 

FK SCOPE_TYPE.ID. This value will be

int

 

 

 

 

populated when user select user defined

 

 

 

 

 

network scope.

 

 

 

 

 

 

 

 

DASHBOARD_ID

FK DASHBOARD.ID. The ID of the dashboard to

int

 

 

 

 

which the preference is applied.

 

 

 

 

 

 

 

 

DASHBOARD_CANVAS_I

FK DASHBOARD_CANVAS.ID. The ID of the

int

 

 

D

 

Canvas in which the dashboard is shown

 

 

 

 

 

 

 

 

 

VISIBLE

 

Visibility of the dashboard. 0 - Not Visible 1 -

smallint

 

 

 

 

Visible.

 

 

 

 

 

 

 

 

 

TIME_SCOPE

 

Time Scope of the Dashboard.

int

 

 

 

 

 

 

 

TABLE 80

DASHBOARD_PROVIDER

 

 

 

 

 

 

 

 

 

Field

 

Definition

Format

Size

 

 

 

 

 

 

 

CLASS_NAME

 

The fully defined class name of the Provider

varchar

128

 

 

 

class. This is stored per widget Provider

 

 

 

 

 

class.

 

 

 

 

 

 

 

 

REFRESH_INTERVAL

Refresh Interval of the Widget in seconds.

int

 

 

 

 

Default is 5 seconds.

 

 

 

Brocade Network Advisor IP User Manual

1397

53-1003056-01

 

Page 1449
Image 1449
Brocade Communications Systems IP250 user manual Database tables and fields Dashboard, Dashboardcanvaspreference