WebSphere Commerce database table: MBRGRPMBR

This table contains members that are explicitly included in a member group.

Column Descriptions
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 as follows:
1=Excluded
0=Included (default)
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235213160 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