WebSphere Commerce database table: RICHATTR
This summary table relates Attribute to AttrValue for each Catalog Entry. It contains pre-computed results based on the data existing in the underlying ATTRIBUTE and ATTRVALUE tables.
Column Descriptions 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. C5 INTEGER NOT NULL Reserved for IBM internal use. Related reference
Indexes Index Name Indexed Column Names Index Type I_RICHATTR NAME+LANGUAGE_ID+CATENTRY_ID+FLOATVALUE+INTEGERVALUE+STRINGVALUE Non-Unique Index