WebSphere Commerce database table: RICHATTRCG

This summary table relates Attribute to AttrValue for Catalog Entries in each CatGroup. It contains pre-computed results based on the data existing in the underlying ATTRIBUTE and ATTRVALUE tables.


Column Description(s):
Column NameColumn TypeDescription
NAME VARCHAR(254) The name given to this attribute. This is the same as the NAME found in the ATTRIBUTE table.
LANGUAGE_ID INTEGER NOT NULL The language to which this attribute pertains. This is the same as the LANGUAGE_ID found in the ATTRIBUTE table. For a list of language components, see the LANGUAGE table.
CATENTRY_ID BIGINT NOT NULL The CatalogEntry that this attribute value describes. This is the same as the CATENTRY_ID found in the ATTRVALUE table.
FLOATVALUE DOUBLE The FLOAT value that this attribute value describes. This is the same as the FLOATVALUE found in the ATTRVALUE table.
INTEGERVALUE INTEGER The INTEGER value that this attribute value describes. This is the same as the INTEGERVALUE found in the ATTRVALUE table.
STRINGVALUE CHAR(254) The STRING value that this attribute value describes. This is the same as the STRINGVALUE found in the ATTRVALUE table.
CATGROUP_ID BIGINT NOT NULL The CatalogGroup for this catalog entry. This is the same as the CATGROUP_ID found in the CATGPENREL table.
C5 INTEGER NOT NULL Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I_RICHATTRCG NAME+LANGUAGE_ID+CATENTRY_ID+FLOATVALUE+INTEGERVALUE+STRINGVALUE+CATGROUP_ID Non-Unique Index

Feedback