STORETRANS

This table links the available site-level transports (specified in the TRANSPORT table) with the store where they are available.

Column Descriptions:

NameTypeDescription
TRANSPORT_IDINTEGER NOT NULLForeign key to the TRANSPORT table. Unique identifier of a transport.
STORE_IDINTEGER NOT NULLForeign key to the STORE table. Unique identifier of a store entity.
ACTIVEINTEGER NOT NULLFlag (0 - inactive or 1 - active) indicating whether this transport is actively linked to the store or whether the link has been logically deleted.
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_ID+STORE_IDPrimary Key
I0000796STORE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_803STORE_IDSTORESTORE_IDCascade
F_804TRANSPORT_IDTRANSPORTTRANSPORT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_282TRANSPORT_ID+STORE_IDCSEDITATTTRANSPORT_ID+STORE_IDCascade