Database Table: CALRULEMGP

A row in this table associates a CalculationRule with a MemberGroup. The discount CalculationRuleQualifyMethod can use this relationship to restrict use of the CalculationRule to members of certain MemberGroups. See the STOREMBRGP table.

Column Name Column Type Column Description
CALRULE_ID INTEGER
NOT NULL
The CalculationRule.
MBRGRP_ID BIGINT
NOT NULL
The MemberGroup. The default CalculationRuleQualifyMethod for discount CalculationUsage uses the MemberGroup as well as CALRULE.FLAGS and the STOREMBRGP relationship table to determine which customers can use the CalculationRule.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034852830 MBRGRP_ID, CALRULE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_173 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_174 CALRULE_ID CALRULE CALRULE_ID Cascade

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