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 Descriptions:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | MBRGRP_ID+PERSONALIZATIONID | Primary Key |
| I0001233 | PERSONALIZATIONID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3592 | MBRGRP_ID | MBRGRP | MBRGRP_ID | Cascade |