Database Table: CATENTATTR

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000063 CATENTRY_ID, LANGUAGE_ID, NAME Unique Index
SQL030416034858910 CATENTATTR_ID Primary Key
Constraints:
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

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