MBRGRPMBR

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:

NameTypeDescription
MEMBER_IDBIGINT NOT NULLForeign 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_IDBIGINT NOT NULLForeign 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.
FIELD1VARCHAR (254)Customizable.
CUSTOMERIDVARCHAR (30)Customizable.
EXCLUDECHAR (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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MEMBER_ID+MBRGRP_IDPrimary Key
I0000615MBRGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_446MEMBER_IDMEMBERMEMBER_IDCascade
F_447MBRGRP_IDMBRGRPMBRGRP_IDCascade