STOREREL

Each row of this table describes a relationship between stores.

Column Descriptions:

Name	Type	Description
STRELTYP_ID	INTEGER NOT NULL	The type of store relationship. See the STRELTYP table.
RELATEDSTORE_ID	INTEGER NOT NULL	The related store identifier.
STORE_ID	INTEGER NOT NULL	The store identifier.
SEQUENCE	DOUBLE NOT NULL DEFAULT 0	The 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.
STATE	INTEGER NOT NULL DEFAULT 1	The state of the relationship. Valid values are as follows: 0 = inactive 1 = active
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>	STORE_ID+STRELTYP_ID+RELATEDSTORE_ID	Primary Key
I0000794	STRELTYP_ID	Non-Unique Index
I0000795	RELATEDSTORE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_916	STORE_ID	STORE	STORE_ID	Cascade
F_917	RELATEDSTORE_ID	STORE	STORE_ID	Cascade
F_919	STRELTYP_ID	STRELTYP	STRELTYP_ID	Cascade