User's Manual

1540 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
TABLE 386 SWITCH_MODEL
Field Definition Format Size
ID* Unique generated database identifier. int
SWBD_TYPE Switch type number, universally used by all the
Management application module implementation.
smallint
SUBTYPE Switch subtype. At present no subtypes for existing
model records are defined.
Default value is 0.
smallint
DESCRIPTION Model description, such as FC link speed, port count
and whether multi-card (director) class switch or
other type of switch.
Default is ‘Not Available’.
varchar 256
MODEL Switch model string. varchar 32
REMARK Remarks, such as an internal project name. varchar 64
SYS_OID This will represent the sys_oid for each product type. varchar 255
PRODUCT_FAMILY This represents the product family that each OID
belongs to.
varchar 128
BRIEF_PRODUCT_FAMILY Shorter name for the product family. varchar 32
SPEED Switch max speed. Value 0 represents NotAvailable. smallint
MULTI_CP_CAPABLE Switch is multi cp cabable or not. 0 means single CP
and 1 means multi.
smallint
MIN_IMAGE_VERSION Supported min firmware version. varchar 64
MAX_IMAGE_VERSION Supported max firmware version. varchar 64
TABLE 387 SWITCH_PORT
Field Definition Format Size
ID* Unique generated database identifier. int
VIRTUAL_SWITCH_ID DB ID of virtual_switch to which this port belongs. int
WWN WWN of the port. char 23
NAME User friendly name of the port. char 32
SLOT_NUMBER Slot number.
Default value is 0.
int
PORT_NUMBER The logical port number of the user port. There is no
assumption of any relation to the physical location of
a port within a chassis.
smallint
USER_PORT_NUMBER User port number. Unique port number in a chassis. smallint
PORT_ID Port ID of this port. varchar 8
PORT_INDEX Number used for identifying port in zoning. smallint
AREA_ID Area number the port is assigned to. smallint
MAC_ADDRESS MAC address of this port. varchar 64
PORT_MOD Stores the port module type. Not applicable if port
doesn't have a GBIC installed.
varchar 64