This table stores member groups defined in the
HCL Commerce system. A member group is a group of members.
Membership is restricted to users within a member group.
Column Descriptions:
| Name | Type | Description |
| MBRGRP_ID | BIGINT NOT NULL | Foreign key to the MEMBER table for this member
group. |
| OWNER_ID | BIGINT NOT NULL | Compare with the
SHOPGRP.SGMENBR column in previous versions of
HCL Commerce. Foreign key to the MEMBER table. |
| FIELD1 | VARCHAR (254) | Customizable. Compare with the
SGFIELD1 column in the
SHOPGRP table in previous versions of WebSphere
Commerce. |
| DESCRIPTION | VARCHAR (512) | Description of the member group. This column is
deprecated. Use MBRGRPDESC.DESCRIPTION instead. |
| FIELD2 | VARCHAR (254) | Customizable. Compare with the SGFIELD2 column in
the SHOPGRP table, which was used with previous versions of
HCL Commerce or HCL Commerce Suite. |
| DN | VARCHAR (1000) | Reserved for HCL internal use. |
| MBRGRPNAME | VARCHAR (254) NOT NULL | Name of this member group. |
| FIELD3 | VARCHAR (254) | Customizable. |
| OID | VARCHAR (64) | This column will have the value 'CMC' if the
member group is created by using the Member Web Service (SOI). |
| LASTUPDATE | TIMESTAMP | The date that this member group was last
updated. |
| LASTUPDATEDBY | VARCHAR (254) | The logon ID of the user that last updated this
member group. |
| ALLOWEXPORT | SMALLINT NOT NULL DEFAULT 0 | Is the customer segment allowed to be exported to
external applications.
- 0 = not allowed
- 1 = allowed
|
| EXPORTALL | SMALLINT NOT NULL DEFAULT 0 | When exporting a customer segment, should all
customers in the segment be included in the list, or just customers
who have opted in to marketing communications.
- 0 = only opt-in customers
- 1 = all customers in the segment
|
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
| UP_MBRGRPNAME | VARCHAR (254) | The equivalent value of the MBRGRPNAME column in
upper case characters. This column is used only for DB2 (LUW)
database-types to enhance performance of text-based searches issued
from Management Center. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | MBRGRP_ID | Primary Key |
| I0000152 | OWNER_ID+MBRGRPNAME | Unique Index |
| IPF00009 | UP_MBRGRPNAME | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_443 | MBRGRP_ID | MEMBER | MEMBER_ID | Cascade |
| F_444 | OWNER_ID | MEMBER | MEMBER_ID | Cascade |
Referenced By Child Tables: