Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PATTRPROD
The relationship table between the PATTRIBUTE and CATENTRY tables.
Column Name Column Type Description PATTRIBUTE_ID BIGINT NOT NULL The internal reference number of the personalization attribute. CATENTRY_ID BIGINT NOT NULL The internal reference number of the CatalogEntry. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030407610 PATTRIBUTE_ID+CATENTRY_ID Primary Key I0000681 CATENTRY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_568 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_567 PATTRIBUTE_ID PATTRIBUTE PATTRIBUTE_ID Cascade
Related reference
_vcc_freeselect_bottom_