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 Descriptions
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
SQL060903235303250 TRANSPORT_ID Primary Key

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