WebSphere Commerce database table: CALCODEMGP

WebSphere Commerce database table: CALCODEMGP

The CalculationCodeQualifyMethod can use the rows of this table to restrict use of a CalculationCode to members of certain MemberGroups.
Column Descriptions
Column Name Column Type Description
CALCODE_ID INTEGER NOT NULL The CalculationCode. See also the FLAGS column of the CALCODE table.
MBRGRP_ID BIGINT NOT NULL The MemberGroup. The default implementation of the CalculationCodeQualifyMethod will only allow use of the CalculationCode by users who are members of the MemberGroup. And only if the MemberGroup appears in the STOREMBGRP table for the Store.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235134780 CALCODE_ID+MBRGRP_ID Primary Key
I0000499 MBRGRP_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_160 CALCODE_ID CALCODE CALCODE_ID Cascade
F_159 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
Related reference

Calculation code data model

Column Name	Column Type	Description
CALCODE_ID	INTEGER NOT NULL	The CalculationCode. See also the FLAGS column of the CALCODE table.
MBRGRP_ID	BIGINT NOT NULL	The MemberGroup. The default implementation of the CalculationCodeQualifyMethod will only allow use of the CalculationCode by users who are members of the MemberGroup. And only if the MemberGroup appears in the STOREMBGRP table for the Store.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
SQL060903235134780	CALCODE_ID+MBRGRP_ID	Primary Key
I0000499	MBRGRP_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_160	CALCODE_ID	CALCODE	CALCODE_ID	Cascade
F_159	MBRGRP_ID	MBRGRP	MBRGRP_ID	Cascade