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 |
