CATENTRYATTR

Stores the catalog entry (CATENTRY) and attribute dictionary attribute (ATTR) relationship. For example, when assigning an attribute dictionary attribute to a catalog entry, a row is created in this table with the details of the relationship between the two objects.

Column Descriptions:

Name	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	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CATENTRY_ID+ATTR_ID+ATTRVAL_ID	Primary Key
I0001202	CATENTRY_ID+USAGE	Non-Unique Index
I0001462	ATTRVAL_ID	Non-Unique Index
I0001463	ATTR_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3566	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_3567	ATTR_ID	ATTR	ATTR_ID	Cascade
F_3568	ATTRVAL_ID	ATTRVAL	ATTRVAL_ID	Cascade