Database Table: STOREREL

This table contains the relationships between stores.

Column Name Column Type Column Description
RELATEDSTORE_ID INTEGER
NOT NULL
The related store identifier.
SEQUENCE DOUBLE
NOT NULL, DEFAULT 0
Defines the selection sequence when more than one related store is defined for the same relationship type.
STATE INTEGER
NOT NULL, DEFAULT 1
The state of the relationship.
0 = inactive
1 = active
STORE_ID INTEGER
NOT NULL
The store identifier.
STRELTYP_ID INTEGER
NOT NULL
The type of store relationship.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035117600 STORE_ID, STRELTYP_ID, RELATEDSTORE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable