Database View: RICHATTR

This summary table relates Attribute CatalogEntries to AttrValue CatalogEntries. 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.
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_RICHATTR NAME, LANGUAGE_ID, CATENTRY_ID, FLOATVALUE, INTEGERVALUE, STRINGVALUE 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