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 Column Description
CALRULE_ID INTEGER
NOT NULL
The CalculationRule for the calculation. CalclationRules are represented by rows in the CALRULE table.
CALSCALE_ID INTEGER
NOT NULL
The CalculationScale for the calculation. CalculationScales are represented by rows in the CALSCALE table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034918750 CALRULE_ID, CALSCALE_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable