STOREREL

Each row of this table describes a relationship between stores.

Column Descriptions:

NameTypeDescription
STRELTYP_IDINTEGER NOT NULLThe type of store relationship. See the STRELTYP table.
RELATEDSTORE_IDINTEGER NOT NULLThe related store identifier.
STORE_IDINTEGER NOT NULLThe store identifier.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The selection sequence number. Used when the store has multiple related stores for the same relationship type. See the Knowledge Center topic "Relationships between stores" for details.
STATEINTEGER NOT NULL DEFAULT 1The state of the relationship. Valid values are as follows: 0 = inactive 1 = active
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STORE_ID+STRELTYP_ID+RELATEDSTORE_IDPrimary Key
I0000794STRELTYP_IDNon-Unique Index
I0000795RELATEDSTORE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_916STORE_IDSTORESTORE_IDCascade
F_917RELATEDSTORE_IDSTORESTORE_IDCascade
F_919STRELTYP_IDSTRELTYPSTRELTYP_IDCascade