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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031218940 CALRULE_ID+CALSCALE_ID Primary Key
I0000550 CALSCALE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_280 CALRULE_ID CALRULE CALRULE_ID Cascade
F_281 CALSCALE_ID CALSCALE CALSCALE_ID Cascade

Feedback