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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I_RICHATTRCG | NAME, LANGUAGE_ID, CATENTRY_ID, FLOATVALUE, INTEGERVALUE, STRINGVALUE, CATGROUP_ID | Non-Unique Index |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|