Database Table: MBRGRPMBR

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

Column Name Column Type Column Description
CUSTOMERID VARCHAR (30)
NULL
Customizable.
EXCLUDE CHARACTER (1)
NOT NULL, DEFAULT '0'
Member excluded indicator:
"1"=Excluded
"0"=Included
FIELD1 VARCHAR (254)
NULL
Customizable.
MBRGRP_ID BIGINT
NOT NULL
Foreign key to the MBRGRP table for 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.
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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034959370 MEMBER_ID, MBRGRP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_446 MEMBER_ID MEMBER MEMBER_ID Cascade
F_447 MBRGRP_ID MBRGRP MBRGRP_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable