This table holds descriptive Attributes for Catalog Entries. These Attributes are only used for descriptive purposes, and not SKU resolution. This table is deprecated and is provided for backward compatibility only.
Column Name | Column Type | Column Description |
---|---|---|
CATENTATTR_ID | BIGINT NOT NULL |
The internal reference number of this CatalogEntry Attribute. |
CATENTRY_ID | BIGINT NOT NULL |
The CatalogEntry that this Attribute describes. |
DESCRIPTION | VARCHAR (254) NULL |
The description of this CatalogEntry Attribute. |
FIELD1 | INTEGER NULL |
Customizable. |
FIELD2 | VARCHAR (254) NULL |
Customizable. |
FIELD3 | VARCHAR (254) NULL |
Customizable. |
LANGUAGE_ID | INTEGER NOT NULL |
The language related to the CatalogEntry Attribute. For a list of language components, see the LANGUAGE table. |
NAME | VARCHAR (254) NOT NULL |
The language-dependent name of this Catalog Entry Attribute. |
VALUE | VARCHAR (254) NOT NULL |
The value associated with this CatalogEntry Attribute. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000063 | CATENTRY_ID, LANGUAGE_ID, NAME | Unique Index |
SQL030416034858910 | CATENTATTR_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_194 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_195 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|