This table holds the relationship between StoreEntities and the Catalogs that they offer.
Column Name | Column Type | Column Description |
---|---|---|
CATALOG_ID | BIGINT NOT NULL |
The reference number of the Catalog. |
LASTUPDATE | TIMESTAMP NULL |
Indicates the last time that this relationship was updated. |
MASTERCATALOG | CHARACTER (1) NULL |
Specifies a master catalog for the Store. A value of 1 indicates that this Catalog is designated as a master catalog. |
STOREENT_ID | INTEGER NOT NULL |
The reference number of the StoreEntity. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035112130 | CATALOG_ID, STOREENT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_778 | CATALOG_ID | CATALOG | CATALOG_ID | Cascade |
F_779 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|