Reference > Database > WebSphere Commerce database tables > T
WebSphere Commerce database table: TRANSPORT
This table is used by the messaging system to store descriptive information about transport methods that are available at the site level.
Column Name Column Type Description TRANSPORT_ID INTEGER NOT NULL Unique identifier for a transport. This primary key must correspond with the ID that identifies a transport in the Configuration Manager. TIMEOUT INTEGER NOT NULL Reserved for IBM internal use. IMPLEMENTED CHAR(1) NOT NULL Flag (Y or N) specifying if this transport is implemented and can be used to create profiles. "N" indicates that this transport is virtually deleted from the system (without physically deleting it and all of its links). ADDRESSABLE CHAR(1) NOT NULL Indicates whether this transport requires address information from the user. Value is one character which can be either Y or N. CODE VARCHAR(2) Code representing entry in LDAP for this transport. NAME VARCHAR(254) NOT NULL Transport name. This column can have up to 254 characters. By default, the names are supplied: EmailSender, File, MQ and Fax for the TRANSPORT_ID of 1, 2, 3 and 4 respectively. DESCRIPTION VARCHAR(254) Transport description. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000256 NAME Unique Index SQL100520030442620 TRANSPORT_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1014 TRANSPORT_ID MSGARCHIVE TRANSPORT_ID Cascade F_1024 TRANSPORT_ID MSGSTORE TRANSPORT_ID Cascade F_1023 TRANSPORT_ID NOTIFY TRANSPORT_ID Cascade F_624 TRANSPORT_ID PROFILE TRANSPORT_ID Cascade F_804 TRANSPORT_ID STORETRANS TRANSPORT_ID Cascade F_893 TRANSPORT_ID USERPVCDEV TRANSPORT_ID Cascade
Related reference
_vcc_freeselect_bottom_