MBRGRP

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:

NameTypeDescription
MBRGRP_IDBIGINT NOT NULLForeign key to the MEMBER table for this member group.
OWNER_IDBIGINT NOT NULLCompare with the SHOPGRP.SGMENBR column in previous versions of HCL Commerce. Foreign key to the MEMBER table.
FIELD1VARCHAR (254)Customizable. Compare with the SGFIELD1 column in the SHOPGRP table in previous versions of WebSphere Commerce.
DESCRIPTIONVARCHAR (512)Description of the member group. This column is deprecated. Use MBRGRPDESC.DESCRIPTION instead.
FIELD2VARCHAR (254)Customizable. Compare with the SGFIELD2 column in the SHOPGRP table, which was used with previous versions of HCL Commerce or HCL Commerce Suite.
DNVARCHAR (1000)Reserved for HCL internal use.
MBRGRPNAMEVARCHAR (254) NOT NULLName of this member group.
FIELD3VARCHAR (254)Customizable.
OIDVARCHAR (64)This column will have the value 'CMC' if the member group is created by using the Member Web Service (SOI).
LASTUPDATETIMESTAMPThe date that this member group was last updated.
LASTUPDATEDBYVARCHAR (254)The logon ID of the user that last updated this member group.
ALLOWEXPORTSMALLINT NOT NULL DEFAULT 0Is the customer segment allowed to be exported to external applications.
  • 0 = not allowed
  • 1 = allowed
EXPORTALLSMALLINT NOT NULL DEFAULT 0When 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
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
UP_MBRGRPNAMEVARCHAR (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:

NameColumn NamesType
<SYSTEM-GENERATED>MBRGRP_IDPrimary Key
I0000152OWNER_ID+MBRGRPNAMEUnique Index
IPF00009UP_MBRGRPNAMENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_443MBRGRP_IDMEMBERMEMBER_IDCascade
F_444OWNER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1030MBRGRP_IDMBRGRPDESCMBRGRP_IDCascade
F_12MBRGRP_IDACCCMDGRPMBRGRP_IDCascade
F_140MBRGRP_IDBUYSUPMAPMBRGRP_IDCascade
F_159MBRGRP_IDCALCODEMGPMBRGRP_IDCascade
F_173MBRGRP_IDCALRULEMGPMBRGRP_IDCascade
F_20MBRGRP_IDACCMBRGRPMBRGRP_IDCascade
F_301MBRGRP_IDDISPCGPRELMBRGRP_IDCascade
F_305MBRGRP_IDDISPENTRELMBRGRP_IDCascade
F_31MBRGRP_IDACPOLICYMBRGRP_IDCascade
F_349MBRGRP_IDFORUMMBRGRP_IDCascade
F_3590MBRGRP_IDMGPCONDELEMBRGRP_IDCascade
F_3592MBRGRP_IDDMMBRGRPPZNMBRGRP_IDCascade
F_445MBRGRP_IDMBRGRPCONDMBRGRP_IDCascade
F_447MBRGRP_IDMBRGRPMBRMBRGRP_IDCascade
F_448MBRGRP_IDMBRGRPUSGMBRGRP_IDCascade
F_461MBRGRP_IDMGPTRDPSCNMBRGRP_IDCascade
F_510MBRGRP_IDORDERMGPMBRGRP_IDCascade
F_63MBRGRP_IDAPRVSTATUSMBRGRP_IDCascade
F_801MBRGRP_IDSTOREMBRGPMBRGRP_IDCascade
F_82MBRGRP_IDAUCTIONMBRGRP_IDCascade
F_88MBRGRP_IDAUCTIONLOGMBRGRP_IDCascade
F_964MBRGRP_IDEMLGRPRELMBRGRP_IDCascade