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:

NameTypeDescription
CATENTRY_IDBIGINT NOT NULLThe reference number of a catalog entry.
ATTR_IDBIGINT NOT NULLThe reference number to an attribute in the ATTR table.
ATTRVAL_IDBIGINT NOT NULL DEFAULT 0The 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.
USAGECHAR (1) NOT NULL'1' for defining attribute (SKU resolution), '2' for descriptive attribute. '0' through '9' are reserved for IBM internal use.
SEQUENCEDOUBLEA number that determines the display order of an attribute for a given catalog entry.
FIELD1INTEGERCustomizable field.
FIELD2INTEGERCustomizable field.
FIELD3VARCHAR (254)Customizable field.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CATENTRY_ID+ATTR_ID+ATTRVAL_IDPrimary Key
I0001202CATENTRY_ID+USAGENon-Unique Index
I0001462ATTRVAL_IDNon-Unique Index
I0001463ATTR_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3566CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_3567ATTR_IDATTRATTR_IDCascade
F_3568ATTRVAL_IDATTRVALATTRVAL_IDCascade