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 Column Description
ADDRESSABLE CHARACTER (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)
NULL
Code representing entry in LDAP for this transport.
DESCRIPTION VARCHAR (254)
NULL
Transport description.
IMPLEMENTED CHARACTER (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).
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.
TIMEOUT INTEGER
NOT NULL
Reserved for IBM internal use.
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.
Indexes:
Index Name Indexed Column Names Index Type
I0000256 NAME Unique Index
SQL030416035136650 TRANSPORT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1014 TRANSPORT_ID MSGARCHIVE TRANSPORT_ID Cascade
F_1023 TRANSPORT_ID NOTIFY TRANSPORT_ID Cascade
F_1024 TRANSPORT_ID MSGSTORE 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