This table contains members that are explicitly
included or excluded from a member group. This works in conjunction
with the implicit inclusion rules that are specified by MBRGRPCOND
table. If both implicit and explicit criteria are specified, the
following algorithm is used to evaluate if a member belongs to a
member group: Explicit exclusion takes first precedence, then
explicit inclusion, and then finally implicit inclusion.
Column Descriptions:
| Name | Type | Description |
| MEMBER_ID | BIGINT NOT NULL | Foreign key to the MEMBER table, the member
associated with the member group. This can be used with the
MCSHNBR column in the
MCUSTINFO table in previous versions of WebSphere
Commerce. |
| MBRGRP_ID | BIGINT NOT NULL | Foreign key to the MBRGRP table, the member group
associated with the member. This can be used with the
MCSGNBR column in the
MCUSTINFO table in previous versions of WebSphere
Commerce. |
| FIELD1 | VARCHAR (254) | Customizable. |
| CUSTOMERID | VARCHAR (30) | Customizable. |
| EXCLUDE | CHAR (1) NOT NULL DEFAULT '0' | Member excluded indicator. Valid values are as
follows:
1=Excluded
0=Included (default)
A member can belong to a member group implicitly by the
CONDITIONS column of the MBRGRPCOND table.
Explicit exclusion takes precedence, then explicit inclusion,
and then finally implicit inclusion. |
| 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> | MEMBER_ID+MBRGRP_ID | Primary Key |
| I0000615 | MBRGRP_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_446 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
| F_447 | MBRGRP_ID | MBRGRP | MBRGRP_ID | Cascade |