MBRGRPUSG

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

Column Descriptions:

NameTypeDescription
MBRGRPTYPE_IDINTEGER NOT NULLForeign key to the MBRGRPTYPE table.
MBRGRP_IDBIGINT NOT NULLForeign key to the MBRGRP table for this member group. This column can be used for the MCSGNBR column in the MCUSTINFO table.
FIELD1VARCHAR (254)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MBRGRPTYPE_ID+MBRGRP_IDPrimary Key
I0000616MBRGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_448MBRGRP_IDMBRGRPMBRGRP_IDCascade
F_449MBRGRPTYPE_IDMBRGRPTYPEMBRGRPTYPE_IDCascade