WebSphere Commerce database table: MBRGRPCOND

This table stores the conditions for an implicit member group.

Column Descriptions
Column Name Column Type Description
MBRGRP_ID BIGINT NOT NULL Foreign key to the MBRGRP table
CONDITIONS CLOB Criteria which define what members qualify to be members of this memberGroup.
FIELD1 VARCHAR(254) Customizable
FIELD2 VARCHAR(254) Customizable
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235212880 MBRGRP_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_445 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
Related reference