MBRGRPCOND

This table stores the conditions for an implicit member group.

Column Descriptions:

NameTypeDescription
MBRGRP_IDBIGINT NOT NULLForeign key to the MBRGRP table
CONDITIONSCLOB (1048576)Criteria which define what members qualify to be members of this memberGroup.
FIELD1VARCHAR (254)Customizable
FIELD2VARCHAR (254)Customizable
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>MBRGRP_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_445MBRGRP_IDMBRGRPMBRGRP_IDCascade