WebSphere Commerce database table: MBRGRPDESC

WebSphere Commerce database table: MBRGRPDESC

This table contains locale specific information for the entries in the MBRGRP table.
Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235213030 MBRGRP_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1031 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_1030 MBRGRP_ID MBRGRP MBRGRP_ID Cascade

Column Name	Column Type	Description
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.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1031	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_1030	MBRGRP_ID	MBRGRP	MBRGRP_ID	Cascade