User's Manual

Brocade Network Advisor IP User Manual 1383
53-1003056-01
Database tables and fields
I
TABLE 52 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 53 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 54 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 55 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 56 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