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 Column Description
FIELD1 VARCHAR (254)
NULL
Reserved for IBM internal use.
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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035000680 MBRGRPTYPE_ID, MBRGRP_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable