Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

1116 Brocade Network Advisor SAN User Manual
53-1002167-01
Database tables and fields
E
TABLE 348 ZONE_TRANSACTION
Field Definition Format Size
FABRIC_ID The id of the fabric on which the zoning transaction is
open. This is the primary key for this table and is a
foreign key from the FABRIC table where
ZONE_TR.FABRIC_ID == FABRIC.ID
int
USER_NAME The Management applciation username of the
cimclient who has opened the zoning transaction on
the fabric. This is a valid Management applciation
username in the Management applciation db
varchar 128
LAST_TIME_USED The last time this transaction was used for timestamp
TABLE 349 ZONE_IN_ZONE_SET
Field Definition Format Size
ZONE_SET_ID PK of the owning zone set int
ZONE_ID PK of the owning zone int
TABLE 350 ZONE_DB_CONFIG
Field Definition Format Size
ID int
ZONE_DB_ID PK of the owning zone DB int
DEFINED_CONTENT defined zone raw config string, wrapped with $ to
prevent special char trimming
text
ACTIVE_CONTENT active zone raw config string text
TI_ZONE_CONTENT ti zone raw config string text
TABLE 351 WT_ARCHIVE
Field Definition Format Size
FIRMWARE_VERSION Firmware version for which jar files are downloaded varchar 128
JAR_LIST List of jar files as comma separated string varchar 256
TABLE 352 V_PORT_DETAIL
Field Definition Format Size
DEVICE_PORT_ID Primary key from the owner device port table. int
STATE Flag to indicate whether port is online or offline varchar 32
FCP_INITIATOR The role of the virtual port; for example, FCP Initiator varchar 256
SWITCH_IP IP of the switch, the V port is connected to varchar 128
VF_ID VF ID for the V port smallint