This table links the available site-level
transports (specified in the TRANSPORT table) with the store where
they are available.
Column Descriptions:
Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | TRANSPORT_ID+STORE_ID | Primary Key |
I0000796 | STORE_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_803 | STORE_ID | STORE | STORE_ID | Cascade |
F_804 | TRANSPORT_ID | TRANSPORT | TRANSPORT_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_282 | TRANSPORT_ID+STORE_ID | CSEDITATT | TRANSPORT_ID+STORE_ID | Cascade |