WebSphere Commerce database table: MBRGRPTYPE

This table stores intended usages that can be associated with member groups.


Column Description(s):
Column NameColumn TypeDescription
MBRGRPTYPE_ID INTEGER NOT NULL Primary key, internally generated.
DESCRIPTION VARCHAR(254) Description of the member group type.
NAME VARCHAR(254) NOT NULL The type of member group. For example, AccessGroup or CustomerGroup.
PROPERTIES VARCHAR(254) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000153 NAME Unique Index
SQL050212031238870 MBRGRPTYPE_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_449 MBRGRPTYPE_ID MBRGRPUSG MBRGRPTYPE_ID Cascade

Feedback