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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031206910 MBRGRP_ID+CALRULE_ID Primary Key
I0000507 CALRULE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_174 CALRULE_ID CALRULE CALRULE_ID Cascade
F_173 MBRGRP_ID MBRGRP MBRGRP_ID Cascade

Feedback