PRSETCEREL

This table holds the expanded (published) form of a ProductSet.

Column Descriptions:

NameTypeDescription
PRODUCTSET_IDINTEGER NOT NULLThe ProductSet ID.
CATENTRY_IDBIGINT NOT NULLThe CatalogEntry ID.
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>PRODUCTSET_ID+CATENTRY_IDPrimary Key
I0000702CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_628PRODUCTSET_IDPRODUCTSETPRODUCTSET_IDCascade
F_629CATENTRY_IDCATENTRYCATENTRY_IDCascade