Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1723)

Brocade Network Advisor SAN User Manual 1671
53-1003154-01
Database tables and fields
H
TABLE 344 RULE_CONDITION_MAP
Field Definition Format Size
POLICY_RULE_ID Foreign key reference to POLICY_RULE.ID. int
CONFIG_CONDITION_ID Foreign key reference to CONFIG_CONDITION.ID. int
TABLE 345 RULE_LOGICAL_EXPRESSION_MAP
Field Definition Format Size
POLICY_RULE_ID Policy rule ID. int
LOGICAL_EXPRESSION_XM
L Configuration Rule Logical Expression XML. text
TABLE 346 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 347 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 switch
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