Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1338 Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
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 114 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 115 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 116 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 117 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
TABLE 113 CLIENT_VIEW_COLUMN (Continued)
Field Definition Format Size