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:

NameTypeDescription
TRANSPORT_IDINTEGER NOT NULLUnique identifier for a transport. This primary key must correspond with the ID that identifies a transport in the Configuration Manager.
TIMEOUTINTEGER NOT NULLReserved for HCL internal use.
IMPLEMENTEDCHAR (1) NOT NULLFlag (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).
ADDRESSABLECHAR (1) NOT NULLIndicates whether this transport requires address information from the user. Value is one character which can be either Y or N.
CODEVARCHAR (2)Code representing entry in LDAP for this transport.
NAMEVARCHAR (254) NOT NULLTransport 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.
DESCRIPTIONVARCHAR (254)Transport description.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TRANSPORT_IDPrimary Key
I0000256NAMEUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1014TRANSPORT_IDMSGARCHIVETRANSPORT_IDCascade
F_1023TRANSPORT_IDNOTIFYTRANSPORT_IDCascade
F_1024TRANSPORT_IDMSGSTORETRANSPORT_IDCascade
F_624TRANSPORT_IDPROFILETRANSPORT_IDCascade
F_804TRANSPORT_IDSTORETRANSTRANSPORT_IDCascade
F_893TRANSPORT_IDUSERPVCDEVTRANSPORT_IDCascade