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 Descriptions:
Name | Type | Description |
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 HCL internal use. |
Indexes:
Name | Column Names | Type |
I_RICHATTRCG |
NAME+LANGUAGE_ID+CATENTRY_ID+FLOATVALUE+INTEGERVALUE+STRINGVALUE+CATGROUP_ID | Non-Unique Index |