Reference > Database > WebSphere Commerce database tables > S
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 Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030434970 TRANSPORT_ID+STORE_ID Primary Key I0000796 STORE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_803 STORE_ID STORE STORE_ID Cascade F_804 TRANSPORT_ID TRANSPORT TRANSPORT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_282 TRANSPORT_ID STORE_ID CSEDITATT TRANSPORT_ID Cascade
Related reference
_vcc_freeselect_bottom_