Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATENTATTR
This table is deprecated and is provided for backward compatibility only. Attributes in this table should be migrated to the ATTRIBUTE and ATTRVALUE tables as descriptive attributes.
Column Name Column Type Description CATENTATTR_ID BIGINT NOT NULL The internal reference number of this catalog entry attribute. LANGUAGE_ID INTEGER NOT NULL The language related to the catalog entries attribute. For a list of language components, see the LANGUAGE table. CATENTRY_ID BIGINT NOT NULL The catalog entry that this attribute describes. NAME VARCHAR(254) NOT NULL The language-dependent name of this catalog entry attribute. VALUE VARCHAR(254) NOT NULL The value associated with this catalog entry attribute. DESCRIPTION VARCHAR(254) The description of this catalog entry attribute. FIELD1 INTEGER Customizable field. FIELD2 VARCHAR(254) Customizable field. FIELD3 VARCHAR(254) Customizable field. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000063 CATENTRY_ID+LANGUAGE_ID+NAME Unique Index SQL100520030310550 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
Related reference
_vcc_freeselect_bottom_