Brocade Network Advisor SAN User Manual v12.1.0 - Manual (Page 1502)

Brocade Network Advisor SAN User Manual 1455
53-1002948-01
Database tables and fields
H
TABLE 289 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 290 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
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
MISSING_TIME Timestamp when the connection went missing timestamp
LAST_UPDATE_TIME Last update time for this record timestamp
CREATION_TIME Creation timestamp timestamp