This table contains members that are explicitly included in a member group.
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 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. |
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031238740 | MEMBER_ID+MBRGRP_ID | Primary Key |
I0000615 | MBRGRP_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_447 | MBRGRP_ID | MBRGRP | MBRGRP_ID | Cascade |
F_446 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |