WebSphere Commerce database table: MBRGRPUSG

This table allows a member group to be associated with multiple member group types (or multiple intended usages).


Column Description(s):
Column NameColumn TypeDescription
MBRGRPTYPE_ID INTEGER NOT NULL Foreign key to the MBRGRPTYPE table.
MBRGRP_ID BIGINT NOT NULL Foreign key to the MBRGRP table for this member group. This column can be used for the MCSGNBR column in the MCUSTINFO table.
FIELD1 VARCHAR(254) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031239000 MBRGRPTYPE_ID+MBRGRP_ID Primary Key
I0000616 MBRGRP_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_448 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_449 MBRGRPTYPE_ID MBRGRPTYPE MBRGRPTYPE_ID Cascade

Feedback