WebSphere Commerce database table: PSETADJMNT

This table stores information on product set adjustments and shows which product set is referenced by a term and condition for a business policy.

Column Descriptions
Column Name Column Type Description
TERMCOND_ID BIGINT NOT NULL The terms and conditions ID.
PRODUCTSET_ID INTEGER NOT NULL The product set ID.
TYPE INTEGER NOT NULL Specifies whether the product set should be included or excluded:
0 = Category inclusion
1 = Category exclusion
2 = Product inclusion
3 = Product exclusion
4 = Browsable inclusion
ADJUSTMENT DECIMAL (20,5) NOT NULL DEFAULT 0 Percentage adjustment on the product set.
PRECEDENCE INTEGER NOT NULL DEFAULT 0 The order in which to apply the adjustment.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235237140 TERMCOND_ID+PRODUCTSET_ID Primary Key
I0000703 PRODUCTSET_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_921 PRODUCTSET_ID PRODUCTSET PRODUCTSET_ID Cascade
F_922 TERMCOND_ID TERMCOND TERMCOND_ID Cascade
Related reference