Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MBRGRPUSG
This table allows a member group to be associated with multiple member group types (or multiple intended usages).
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030354410 MBRGRPTYPE_ID+MBRGRP_ID Primary Key I0000616 MBRGRP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_448 MBRGRP_ID MBRGRP MBRGRP_ID Cascade F_449 MBRGRPTYPE_ID MBRGRPTYPE MBRGRPTYPE_ID Cascade
Related reference
_vcc_freeselect_bottom_