WebSphere Commerce database table: CATENTATTR

This table is deprecated and is provided for backward compatibility only.


Column Description(s):
Column NameColumn TypeDescription
CATENTATTR_ID BIGINT NOT NULL The internal reference number of this CatalogEntry Attribute.
LANGUAGE_ID INTEGER NOT NULL The language related to the CatalogEntry Attribute. For a list of language components, see the LANGUAGE table.
CATENTRY_ID BIGINT NOT NULL The CatalogEntry that this Attribute describes.
NAME VARCHAR(254) NOT NULL The language-dependent name of this CatalogEntry Attribute.
VALUE VARCHAR(254) NOT NULL The value associated with this CatalogEntry Attribute.
DESCRIPTION VARCHAR(254) The description of this CatalogEntry Attribute.
FIELD1 INTEGER Customizable.
FIELD2 VARCHAR(254) Customizable.
FIELD3 VARCHAR(254) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000063 CATENTRY_ID+LANGUAGE_ID+NAME Unique Index
SQL050212031208610 CATENTATTR_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_194 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_195 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Feedback