Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATENTRYATTR
Stores the catalog entry attribute relation.
Column Name Column Type Description CATENTRY_ID BIGINT NOT NULL The reference number of a catalog entry. ATTR_ID BIGINT NOT NULL The reference number to an attribute in the ATTR table. ATTRVAL_ID BIGINT NOT NULL DEFAULT 0 The reference number to an attribute in the ATTRVAL table. The value 0 means the attribute is assigned to the catalog entry without a specific value. USAGE CHAR(1) NOT NULL '1' for defining attribute (sku resolution), '2' for descriptive attribute. '0' through '9' are reserved for IBM internal use. SEQUENCE DOUBLE A number that determines the display order of an attribute for a given catalog entry. FIELD1 INTEGER Customizable field. FIELD2 INTEGER Customizable field. FIELD3 VARCHAR(254) Customizable field. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type SQL100520030311200 CATENTRY_ID+ATTR_ID+ATTRVAL_ID Primary Key I0001202 CATENTRY_ID+USAGE Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3567 ATTR_ID ATTR ATTR_ID Cascade F_3568 ATTRVAL_ID ATTRVAL ATTRVAL_ID Cascade F_3566 CATENTRY_ID CATENTRY CATENTRY_ID Cascade _vcc_freeselect_bottom_