Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CATGRPATTR

This table holds descriptive attributes for catalog groups. These attributes are only used for descriptive purposes. This table is deprecated and is provided for backward compatibility only.

Column Name Column Type Description
CATGRPATTR_ID BIGINT NOT NULL The internal reference number of this catalog group attribute.
LANGUAGE_ID INTEGER NOT NULL The language to which this catalog group attribute relates. For a list of language components, see the LANGUAGE table.
CATGROUP_ID BIGINT NOT NULL The catalog group described by this attribute.
NAME VARCHAR(254) NOT NULL The language-dependent name of this catalog group attribute.
DESCRIPTION VARCHAR(254) The description of this catalog group attribute.
OID CHAR(32) Reserved for IBM internal use.
SEQUENCE DOUBLE The sequence number that is used to determine the display order.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000068 CATGROUP_ID+LANGUAGE_ID+NAME Unique Index
SQL100520030312150 LANGUAGE_ID+CATGRPATTR_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_217 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_218 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search