WebSphere Commerce database table: CATGRPATTR

This table holds descriptive attributes for CatalogGroups. These attributes are only used for descriptive purposes.


Column Description(s):
Column NameColumn TypeDescription
CATGRPATTR_ID BIGINT NOT NULL The internal reference number of this CatalogGroup Attribute.
LANGUAGE_ID INTEGER NOT NULL The language to which this CatalogGroup Attribute relates. For a list of language components, see the LANGUAGE table.
CATGROUP_ID BIGINT NOT NULL The CatalogEntryGroup described by this Attribute.
NAME VARCHAR(254) NOT NULL The language-dependent name of this CatalogGroup Attribute.
DESCRIPTION VARCHAR(254) The description of this CatalogGroup 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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000068 CATGROUP_ID+LANGUAGE_ID+NAME Unique Index
SQL050212031209960 LANGUAGE_ID+CATGRPATTR_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_217 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_218 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Feedback