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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035117600 | STORE_ID, STRELTYP_ID, RELATEDSTORE_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|