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.
OPTCOUNTERSMALLINTThe 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