WebSphere Commerce database table: MBRGRPDESC

This table contains locale specific information for the entries in the MBRGRP table.


Column Description(s):
Column NameColumn TypeDescription
MBRGRP_ID BIGINT NOT NULL The Member Group ID. Foreign key to the MBRGRP table.
LANGUAGE_ID INTEGER NOT NULL The Language ID. Foreign key to the LANGUAGE table. For a list of language components, see the LANGUAGE table.
DISPLAYNAME VARCHAR(254) NOT NULL The name of the member group for display purposes.
DESCRIPTION VARCHAR(4000) Description of the member group.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031238600 MBRGRP_ID+LANGUAGE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1031 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_1030 MBRGRP_ID MBRGRP MBRGRP_ID Cascade

Feedback