Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce 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 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. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030308730 MBRGRP_ID+CALRULE_ID Primary Key I0000507 CALRULE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_174 CALRULE_ID CALRULE CALRULE_ID Cascade F_173 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
Related reference
_vcc_freeselect_bottom_