Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMMBRGRPPZN
This table contains customers that are explicitly included in a member group by the customer's personalization ID. This works in conjunction with the explicit inclusion and exclusion rules that are specified in the MBRGRPMBR table and the implicit inclusion rules that are specified in the MBRGRPCOND table. If both multiple criteria are specified, the following algorithm is used to evaluate if a member belongs to a member group: Explicit exclusion by member ID takes first precedence, then explicit inclusion by member ID, then inclusion by personalization ID, and then finally implicit inclusion.
Column Name Column Type Description MBRGRP_ID BIGINT NOT NULL Foreign key to the MBRGRP for this member group. PERSONALIZATIONID VARCHAR(30) NOT NULL The unique personalization identifier of a customer. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030328520 MBRGRP_ID+PERSONALIZATIONID Primary Key I0001233 PERSONALIZATIONID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3592 MBRGRP_ID MBRGRP MBRGRP_ID Cascade _vcc_freeselect_bottom_