Brocade Network Advisor IP User Manual 1467
53-1003056-01
Database tables and fields I
TABLE 19 3 ISL_TRUNK_MEMBER
Field Definition Format Size
GROUP_ID* Foreign key reference to the trunk group table for this
member.
int
PORT_NUMBER* Member port number for this trunk.. smallint
TRUSTED Denotes whether ISL trunk member is trusted or not.
0 denotes untrusted and 1 is for trusted.
smallint
MISSING Denotes whether ISL trunk member is mis sing or not.
0 denotes present and 1 states that ISL trunk
member is missing.
smallint
MISSING_TIME We could change this as "States the missing time of
the this ISL trunk member. If the member is not
missing then it will be null.
timestamp
TABLE 194 KEY_VAULT
Field Definition Format Size
ID Unique generated database identifier. int
IP_ADDRESS The IP Address (IPv4, IPv6, or hostname) of the key
vault
varchar( 512
PORT_NUMBER The TCP port number for the key vault int
PUBLIC_CERTIFICATE The key vault''s public key certificate. Switches use
this to establish a secure connection to the key vault
varchar( 4096
CERTIFICATE_LABEL A text name to identify the certificate varchar( 256
POSITION_ Specifies whether this key vault is the primary key vault
or the backup key vault. 0 = primary, 1 = backup.
smallint
VENDOR_NAME Indicates the name of the key vault vendor. For non
KMIP key vaults, this column will contain value as Not
Applicable.
varchar 256
TABLE 19 5 L2_ACCESS_CONTROL_ENTRY
Field Definition Format Size
ID serial
ACCESS_CONTROL_LIST_ID L2 access control list ID, to which the ACL entry is
associated.
int
SEQUENCE_NUMBER int
ACTION Specifies the action:
0 = Permit
1 = Deny
smallint
SOURCE_MAC Source MAC address. varchar 24
SOURCE__MASK Source MAC address mask. varchar 24
DEST_MAC Destination MAC address. varchar 24
DEST_MASK Destination MAC address mask. varchar 24
VLAN_ID Specifies the VLAN ID for the L2 ACL entry. int