Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CATGROUP

This table hold the information related to a catalog group. A catalog group is similar to a generic category that can contain both other catalog groups and also catalog entries.

Column Name Column Type Description
CATGROUP_ID BIGINT NOT NULL The internal reference number of the catalog group.
MEMBER_ID BIGINT NOT NULL The internal reference number that identifies the owner of the catalog group. Along with IDENTIFIER, these columns are a unique index.
IDENTIFIER VARCHAR(254) The external name that is used to identify the catalog group. Along with MEMBER_ID, these columns are a unique index.
MARKFORDELETE INTEGER NOT NULL Indicates if this catalog group has been marked for deletion:
0 = No.
1 = Yes.
LASTUPDATE TIMESTAMP Indicates the last time that this catalog group was updated.
FIELD1 VARCHAR(254) Customizable.
FIELD2 VARCHAR(254) Customizable.
OID VARCHAR(64) Reserved for IBM internal use.
RANK DOUBLE Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000067 IDENTIFIER+MEMBER_ID Unique Index
SQL100520030312000 CATGROUP_ID Primary Key
I0000376 RANK Non-Unique Index
I0000525 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_216 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_210 CATGROUP_ID CATGPCALCD CATGROUP_ID Cascade
F_213 CATGROUP_ID CATGPENREL CATGROUP_ID Cascade
F_217 CATGROUP_ID CATGRPATTR CATGROUP_ID Cascade
F_219 CATGROUP_ID CATGRPDESC CATGROUP_ID Cascade
F_222 CATGROUP_ID CATGRPPS CATGROUP_ID Cascade
F_224 CATGROUP_ID_CHILD CATGRPREL CATGROUP_ID Cascade
F_225 CATGROUP_ID_PARENT CATGRPREL CATGROUP_ID Cascade
F_229 CATGROUP_ID CATGRPTPC CATGROUP_ID Cascade
F_231 CATGROUP_ID CATTOGRP CATGROUP_ID Cascade
F_977 CATGROUP_ID CPPMNCAT CATGROUP_ID Cascade
F_298 CATGROUP_ID DISPCGPREL CATGROUP_ID Cascade
F_361 CATGROUP_ID ICEXPLFEAT CATGROUP_ID Cascade
F_948 ROOTCATEGORYID ICROOTCAT CATGROUP_ID Cascade
F_376 CATGROUP_ID ICROOTCAT CATGROUP_ID Cascade
F_3620 CATGROUP_ID INSRULECATGRP CATGROUP_ID Cascade
F_435 CATGROUP_ID_TO MASSOCGPGP CATGROUP_ID Cascade
F_436 CATGROUP_ID_FROM MASSOCGPGP CATGROUP_ID Cascade
F_783 CATGROUP_ID STORECGRP CATGROUP_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search