Database Table: STORECAT

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035112130 CATALOG_ID, STOREENT_ID Primary Key
Constraints:
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

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