PATTRPROD

The relationship table between the PATTRIBUTE and CATENTRY tables.

Column Descriptions:

NameTypeDescription
PATTRIBUTE_IDBIGINT NOT NULLThe internal reference number of the personalization attribute.
CATENTRY_IDBIGINT NOT NULLThe internal reference number of the CatalogEntry.
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>PATTRIBUTE_ID+CATENTRY_IDPrimary Key
I0000681CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_567PATTRIBUTE_IDPATTRIBUTEPATTRIBUTE_IDCascade
F_568CATENTRY_IDCATENTRYCATENTRY_IDCascade