WebSphere Commerce database table: CRULESCALE

Each row in this table shows that a CalculationRule is associated with a CalculationScale. Both are used by the Calculation Framework for discounts, shipping charges, taxes, and so on.

Column Descriptions
Column Name Column Type Description
CALSCALE_ID INTEGER NOT NULL The CalculationScale for the calculation. CalculationScales are represented by rows in the CALSCALE table.
CALRULE_ID INTEGER NOT NULL The CalculationRule for the calculation. CalclationRules are represented by rows in the CALRULE table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235148670 CALRULE_ID+CALSCALE_ID Primary Key
I0000550 CALSCALE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_280 CALRULE_ID CALRULE CALRULE_ID Cascade
F_281 CALSCALE_ID CALSCALE CALSCALE_ID Cascade
Related reference