This table stores member group condition elements.

Column Descriptions:

MGPCONDELE_IDBIGINT NOT NULLThe member group condition element ID. The value can be up to 254 characters.
MBRGRP_IDBIGINT NOT NULLThe MemberGroup ID. It is the foreign key to the MBRGRP table.
NAMEVARCHAR (64) NOT NULLThe MemberGroup condition element name. It should be unique within a MemberGroup.
TYPEVARCHAR (64) NOT NULLThe member group condition element type.
PARENTVARCHAR (64)The parent element name.
SEQUENCEDOUBLEThe sequence number provided by Management Center.
VARIABLEVARCHAR (254)The condition variable name.
OPERATORVARCHAR (16)The condition operator.
VALUEVARCHAR (254)The condition value.
CONDNAMEVARCHAR (254)The condition name, if a name exists. Only the openCondition requires the name.
NEGATESMALLINT NOT NULL DEFAULT 0The flag indicating whether the condition results will be negated.
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.


NameColumn NamesType
I0001230NAME+MBRGRP_IDUnique Index
I0001231MBRGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType