Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1281
53-1002696-01
Database tables and fields
H
PRIVILEGE_ID* Privilege ID. int
PERMISSION Privilege permission:
1 = RO
2 = RW
0 = No privilege
Default value is 0.
smallint
TABLE 287 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 288 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
TABLE 286 ROLE_PRIVILEGE_MAP (Continued)
Field Definition Format Size