MBRGRP
This table stores member groups defined in the WebSphere 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 WebSphere 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 WebSphere Commerce or WebSphere Commerce Suite. DN VARCHAR (1000) Reserved for IBM 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 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 via UBX.
- 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:
Constraint Columns Child Table Child Columns Type F_1030 MBRGRP_ID MBRGRPDESC MBRGRP_ID Cascade F_12 MBRGRP_ID ACCCMDGRP MBRGRP_ID Cascade F_140 MBRGRP_ID BUYSUPMAP MBRGRP_ID Cascade F_159 MBRGRP_ID CALCODEMGP MBRGRP_ID Cascade F_173 MBRGRP_ID CALRULEMGP MBRGRP_ID Cascade F_20 MBRGRP_ID ACCMBRGRP MBRGRP_ID Cascade F_301 MBRGRP_ID DISPCGPREL MBRGRP_ID Cascade F_305 MBRGRP_ID DISPENTREL MBRGRP_ID Cascade F_31 MBRGRP_ID ACPOLICY MBRGRP_ID Cascade F_349 MBRGRP_ID FORUM MBRGRP_ID Cascade F_3590 MBRGRP_ID MGPCONDELE MBRGRP_ID Cascade F_3592 MBRGRP_ID DMMBRGRPPZN MBRGRP_ID Cascade F_445 MBRGRP_ID MBRGRPCOND MBRGRP_ID Cascade F_447 MBRGRP_ID MBRGRPMBR MBRGRP_ID Cascade F_448 MBRGRP_ID MBRGRPUSG MBRGRP_ID Cascade F_461 MBRGRP_ID MGPTRDPSCN MBRGRP_ID Cascade F_510 MBRGRP_ID ORDERMGP MBRGRP_ID Cascade F_63 MBRGRP_ID APRVSTATUS MBRGRP_ID Cascade F_801 MBRGRP_ID STOREMBRGP MBRGRP_ID Cascade F_82 MBRGRP_ID AUCTION MBRGRP_ID Cascade F_88 MBRGRP_ID AUCTIONLOG MBRGRP_ID Cascade F_964 MBRGRP_ID EMLGRPREL MBRGRP_ID Cascade
Related reference
Access control data model
Calculation code data model
Calculation rule data model
Calculation rule - discount data model
Catalog entry data model
Catalog group data model
Member data model
Messaging extension data model
Offers data model
Order data model
Procurement data model
Authentication data model
Store data model