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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034959370 | MEMBER_ID, MBRGRP_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|