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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000152 | OWNER_ID, MBRGRPNAME | Unique Index |
SQL030416034957420 | MBRGRP_ID | Primary Key |
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 |
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 |