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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035118240 | TRANSPORT_ID, STORE_ID | Primary Key |
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 |
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 |