WebSphere Commerce database table: STORECGRP

STORECGRP

Relationship between StoreEntities and the CatalogGroups that they can display and process.

Column Descriptions:

Name Type Description
STOREENT_ID INTEGER NOT NULL The reference number of the Store Entity.
CATGROUP_ID BIGINT NOT NULL The reference number of the Catalog Group.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> STOREENT_ID+CATGROUP_ID Primary Key
I0000783 CATGROUP_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_782 STOREENT_ID STOREENT STOREENT_ID Cascade
F_783 CATGROUP_ID CATGROUP CATGROUP_ID Cascade

Related reference
Catalog group data model

Name	Type	Description
STOREENT_ID	INTEGER NOT NULL	The reference number of the Store Entity.
CATGROUP_ID	BIGINT NOT NULL	The reference number of the Catalog Group.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Name	Column Names	Type
<SYSTEM-GENERATED>	STOREENT_ID+CATGROUP_ID	Primary Key
I0000783	CATGROUP_ID	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_782	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_783	CATGROUP_ID	CATGROUP	CATGROUP_ID	Cascade