Brocade Network Advisor IP User Manual 1517
53-1003056-01
Database tables and fields I
TABLE 337 RULE_LOGICAL_EXPRESSION_MAP
Field Definition Format Size
POLICY_RULE_ID Policy rule ID. int
LOGICAL_EXPRES SION_XM
L
Configuration Rule Logical Expression XML. text
TABLE 33 8 SAN
Field Definition Format Size
ID* Unique generated database identifier. int
NAME Name of this SAN. varchar 256
CONTACT Contact person for this SAN. varchar 256
LOCATION Location of this SAN. varchar 256
DESCRIPTION Description. varchar 256
STATS_COLLECTION 1 = statistics collection is enabled; otherwise, 0.
Default value is 0.
smallint
CREATION_TIME time at which this record was created.
Default value is ’now()’.
timestamp
LAST_UPDATE_TIME time when this was last updated.
Default value is ’now()’.
timestamp
TABLE 33 9 SAN_CONNECTION
Field Definition Format Size
ID Unique generated database identifier. serial
SOURCE_SWITCH_ID Foreign key to VIRTUAL_SWITCH table. This is the
virtual switch ID of AG
int
SOURCE_PORT_ID Foreign key to SWITCH_PORT table. This is the switch
port id of N-port
int
SOURCE_PORT_WWN WWN of the AG N port varchar 32
SOURCE_PORT_TYPE Type of source port varchar 16
SOURCE_USER_PORT_NUM
BER
User port number of AG N port smallint
DESTINATION_SWITCH_ID Foreign key to VIRTUAL_SWITCH table. This is the
virtual switch ID of edge switch
int
DESTINATION_PORT_ID Foreign key to SWITCH_PORT table . This is the swi tch
port id of F-port
int
DESTINATION_PORT_WWN WWN of the F port varchar 23
DESTINATION_PORT_TYPE Type of destination port varchar 16
DESTINATION_USER_PORT_
NUMBER
User port number of F-port smallint
FABRIC_ID Foreign key to FABRIC table int
TRUSTED Indicates if the connection is trusted smallint
MISSING Indicates if the connection is missing smallint