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 Column Description
ACTIVE INTEGER
NOT NULL
Flag (Y or N) indicating whether this transport is actively linked to the store or whether the link has been logically deleted.
STORE_ID INTEGER
NOT NULL
Foreign key to the STORE table. Unique identifier of a store entity.
TRANSPORT_ID INTEGER
NOT NULL
Foreign key to the TRANSPORT table. Unique identifier of a transport.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035118240 TRANSPORT_ID, STORE_ID Primary Key
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+STORE_ID Cascade