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 Name | Column 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 IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I_RICHATTRCG |
NAME+LANGUAGE_ID+CATENTRY_ID+FLOATVALUE+INTEGERVALUE+STRINGVALUE+CATGROUP_ID |
Non-Unique Index |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.