Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: 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 Name Column Type Description MEMBER_ID BIGINT NOT NULL Foreign key to the MEMBER table for the group member. This can be used for the MCSHNBR column in the MCUSTINFO table, which was used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. MBRGRP_ID BIGINT NOT NULL Foreign key to the MBRGRPfor this member group. This can be used for the MCSGNBR column in the MCUSTINFO table, which was used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. FIELD1 VARCHAR(254) Customizable. CUSTOMERID VARCHAR(30) Customizable. EXCLUDE CHAR(1) NOT NULL DEFAULT '0' Member excluded indicator. Valid values are...
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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030354090 MEMBER_ID+MBRGRP_ID Primary Key I0000615 MBRGRP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_447 MBRGRP_ID MBRGRP MBRGRP_ID Cascade F_446 MEMBER_ID MEMBER MEMBER_ID Cascade
Related reference
_vcc_freeselect_bottom_