WebSphere Commerce database table: STOREREL

Each row of this table describes a relationship between stores.


Column Description(s):
Column NameColumn TypeDescription
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 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 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031315930 STORE_ID+STRELTYP_ID+RELATEDSTORE_ID Primary Key
I0000794 STRELTYP_ID Non-Unique Index
I0000795 RELATEDSTORE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint 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

Feedback