Database View: RICHATTRCG

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

Column Name Column Type Column Description
C5 INTEGER
NOT NULL
Count of the number of rows. Required by definition of summary tables.
CATENTRY_ID BIGINT
NOT NULL
The CatalogEntry that this Attribute Value describes. It is CATENTRY_ID found in the ATTRVALUE table.
CATGROUP_ID BIGINT
NOT NULL
The CatalogGroup for this catalog entry. It is CATGROUP_ID found in the CATGPENREL table.
FLOATVALUE DOUBLE
NULL
The FLOAT value that this attribute value describes. It is FLOATVALUE found in the ATTRVALUE table.
INTEGERVALUE INTEGER
NULL
The INTEGER value that this attribute value describes. It is INTEGERVALUE found in the ATTRVALUE table.
LANGUAGE_ID INTEGER
NOT NULL
The Language that this Attribute pertains to. It is LANGUAGE_ID found in the ATTRIBUTE table. For a list of language components, see the LANGUAGE table.
NAME VARCHAR (254)
NULL
The name given to this Attribute. It is NAME found in the ATTRIBUTE table.
STRINGVALUE CHARACTER (254)
NULL
The STRING value that this attribute value describes. It is STRINGVALUE found in the ATTRVALUE table.
Indexes:
Index Name Indexed Column Names Index Type
I_RICHATTRCG NAME, LANGUAGE_ID, CATENTRY_ID, FLOATVALUE, INTEGERVALUE, STRINGVALUE, CATGROUP_ID Non-Unique Index
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable