Reference > Database > WebSphere Commerce database tables > C
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 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 SQL100520030322190 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
_vcc_freeselect_bottom_