Database Table: 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 Name Column Type Column Description
DESCRIPTION VARCHAR (512)
NULL
Description of the member group.
DN VARCHAR (1000)
NULL
Reserved for IBM internal use.
FIELD1 VARCHAR (254)
NULL
Customizable. Compare with the SGFIELD1 column in the SHOPGRP table, which was used with previous versions of WebSphere Commerce or WebSphere Commerce Suite.
FIELD2 VARCHAR (254)
NULL
Customizable. Compare with the SGFIELD2 column in the SHOPGRP table, which was used with previous versions of WebSphere Commerce or WebSphere Commerce Suite.
FIELD3 VARCHAR (254)
NULL
Customizable.
LASTUPDATE TIMESTAMP
NULL
The date that this member group was last updated.
LASTUPDATEDBY VARCHAR (254)
NULL
The logon ID of the user that last updated this member group.
MBRGRPNAME VARCHAR (254)
NOT NULL
Name of this member group.
MBRGRP_ID BIGINT
NOT NULL
Foreign key to the MEMBER table for this member group.
OID VARCHAR (64)
NULL
Reserved for IBM internal use.
OWNER_ID BIGINT
NOT NULL
Compare with the SGMENBR column in the SHOPGRP table, which was used with previous versions of WebSphere Commerce or WebSphere Commerce Suite. Foreign key to the MEMBER table for the owner of this member group.
Indexes:
Index Name Indexed Column Names Index Type
I0000152 OWNER_ID, MBRGRPNAME Unique Index
SQL030416034957420 MBRGRP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_443 MBRGRP_ID MEMBER MEMBER_ID Cascade
F_444 OWNER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint 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_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