WebSphere Commerce database table: STORETRANS

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


Column Description(s):
Column NameColumn TypeDescription
TRANSPORT_ID INTEGER NOT NULL Foreign key to the TRANSPORT table. Unique identifier of a transport.
STORE_ID INTEGER NOT NULL Foreign key to the STORE table. Unique identifier of a store entity.
ACTIVE INTEGER NOT NULL Flag (0 - inactive or 1 - active) indicating whether this transport is actively linked to the store or whether the link has been logically deleted.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031316090 TRANSPORT_ID+STORE_ID Primary Key
I0000796 STORE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_803 STORE_ID STORE STORE_ID Cascade
F_804 TRANSPORT_ID TRANSPORT TRANSPORT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_282 TRANSPORT_ID STORE_ID CSEDITATT TRANSPORT_ID Cascade

Feedback