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 Descriptions
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
SQL060903235135880 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