Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1584

Advertising
background image

1532

Brocade Network Advisor SAN User Manual

53-1003154-01

Database tables and fields

H

TABLE 55

CLIENT_VIEW_COLUMN

Field

Definition

Format

Size

ID *

Unique generated database identifier.

int

NAME

Name of the column. It is used as column header in
product list and property name in property sheet(SAN
and IP)

varchar

255

ENTITY_CATEGORY

Holds the type of the entity to whom the column name
belongs to like Port, Fabric, IPProduct, VCSInterface,
etc'

varchar

128

COLUMN_INDEX

Used to differentiate user defined columns and static
columns. For static it is 0 and for user defined columns
it is 1,2,3.

small int

DESCRIPTION

Holds description of the column.

varchar

255

ICON_ID

Holds Icon Id for the column. Currently it is unused.

int

VISIBLE

Indicates whether the columns are visible. 0 - Not
Visible, 1 - Visible

smallint

EDITABLE

Indicates whether the columns are editable. 0 - Not
Editable, 1 - Editable.

smallint

TABLE 56

CLIENT_VIEW_MEMBER

Field

Definition

Format

Size

CLIENT_VIEW_ID *

Foreign key to CLIENT_VIEW table.

int

FABRIC_ID *

Foreign key to FABRIC table.

int

TABLE 57

CLIENT_VIEW_MEMBER_HOST

Field

Definition

Format

Size

CLIENT_VIEW_ID

Primary key of CLIENT_VIEW table

int

HOST_ID

Primary key of DEVICE_ENCLOSURE table

int

TABLE 58

CLUSTER

Field

Definition

Format

Size

ID *

Arbitrary integer to identify the cluster.

int

NAME

User-assigned name to identify the cluster. Names
should be unique to avoid user confusion,
but the database does not enforce uniqueness.

varchar

64

IP_ADDRESS

The primary hostname or IP address for managing the
cluster as a single entity.
The definition of primary depends on the clustering
technology.

varchar

64

TABLE 59

CLUSTER_MEMBER

Field

Definition

Format

Size

CLUSTER_ID

Identifies the cluster containing a member.

int

DEVICE_ENCLOSURE_ID

Identifies a member of the cluster.

int

32

Advertising