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 | 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 |