Brocade Network Advisor IP User Manual v12.3.0 - Manual (Page 1578)

1526 Brocade Network Advisor IP User Manual
53-1003153-01
Database tables and fields
I
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