WebSphere Commerce database table: PATTRPROD
The relationship table between the PATTRIBUTE and CATENTRY tables.
Column Descriptions
| 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 |
| SQL060903235226050
| 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