User Manual v12.1.0 Instruction Manual

Brocade Network Advisor SAN + IP User Manual 2129
53-1002949-01
Database tables and fields
I
TABLE 272 LSAN_ZONE_MEMBER
Field Definition Format Size
LSAN_ZONE_ID* LSAN_ZONE record reference. int
MEMBER_PORT_WWN* Zone member WWN. char 23
TABLE 273 MCT_CLIENT
Field Definition Format Size
MCT_CLIENT_ID MCT Client db ID. int
RBRIDGE_ID MCT Client rbridge ID. int
CLIENT_NAME MCT Client name. varchar (100)
PORT_ID MCT Client port foreign key. int
OPER_STATE MCT Client operational state. smallint
DEPLOY_STATE MCT Client deployment state:
• Deployed(0)
• Undeployed(1)
smallint
VCN_MEMBER_ID Virtual Cluster Node member Cluster id foreign key. int
TABLE 275 MAC_FILTER_DEV_DEPLOYMENT_MAP
Field Definition Format Size
DEPLOYMENT_ID Deployment configuration ID. int
MAC_FILTER_ID MAC FILTER Id for reference to the MAC_FILTER. int
TABLE 276 MAC_FILTER_INT_DEPLOYMENT_MAP
Field Definition Format Size
ID Unique generated database identifier. serial
DEPLOYMENT_ID Deployment configuration ID. Foreign Key for
DEPLOYMENT table.
int
INBOUND_MAC_FILTER_ID MAC FILTER Id of the MAC Filter selected for inbound.
Foreign Key for MAC_FILTER table.
int
INBOUND_WRITE_TO_DEVICE 1/0 corresponding to Write to device/not write to
device for inbound traffic.
smallint
TABLE 277 MANAGED_ELEMENT
Field Definition Format Size
ID An ID that is unique across managed elements of all
types: SAN physical switches, SAN logical switches, IP
switches, and hosts. Also the primary key for the
MANAGED_ELEMENT table.
int
PLACEHOLDER Not used. iBatis/Abator requires at least one non-serial
column to generate correct objects. The default value is
0.
int