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 Description(s):
Column Name | Column Type | Description |
MBRGRP_ID |
BIGINT NOT NULL |
Foreign key to the MEMBER table for this member group. |
OWNER_ID |
BIGINT NOT NULL |
Represents the organization that owns this member group. |
FIELD1 |
VARCHAR(254) |
Customizable. Compare with the SGFIELD1 column in the SHOPGRP table, which was used with previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
DESCRIPTION |
VARCHAR(512) |
Description of the member group. |
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) |
Reserved for IBM internal use. |
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. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000152 |
OWNER_ID+MBRGRPNAME |
Unique Index |
SQL050212031238330 |
MBRGRP_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 Name(s) | Constraint Type |
F_12 |
MBRGRP_ID |
ACCCMDGRP |
MBRGRP_ID |
Cascade |
F_20 |
MBRGRP_ID |
ACCMBRGRP |
MBRGRP_ID |
Cascade |
F_31 |
MBRGRP_ID |
ACPOLICY |
MBRGRP_ID |
Cascade |
F_63 |
MBRGRP_ID |
APRVSTATUS |
MBRGRP_ID |
Cascade |
F_82 |
MBRGRP_ID |
AUCTION |
MBRGRP_ID |
Cascade |
F_88 |
MBRGRP_ID |
AUCTIONLOG |
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_301 |
MBRGRP_ID |
DISPCGPREL |
MBRGRP_ID |
Cascade |
F_305 |
MBRGRP_ID |
DISPENTREL |
MBRGRP_ID |
Cascade |
F_964 |
MBRGRP_ID |
EMLGRPREL |
MBRGRP_ID |
Cascade |
F_349 |
MBRGRP_ID |
FORUM |
MBRGRP_ID |
Cascade |
F_445 |
MBRGRP_ID |
MBRGRPCOND |
MBRGRP_ID |
Cascade |
F_1030 |
MBRGRP_ID |
MBRGRPDESC |
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_801 |
MBRGRP_ID |
STOREMBRGP |
MBRGRP_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.