CONTRLRULE

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
RULE_IDBIGINT NOT NULLReserved for IBM internal use.
OWNER_IDBIGINT NOT NULLReserved for IBM internal use.
CLASS_IDBIGINT NOT NULLReserved for IBM internal use.
ADMIN_IDBIGINTReserved for IBM internal use.
RULETYPECHAR (4) NOT NULLReserved for IBM internal use.
RULENAMECHAR (30) NOT NULLReserved for IBM internal use.
RULEDESCVARCHAR (254)Reserved for IBM internal use.
MINQUANTDOUBLEReserved for IBM internal use.
MINVALUEDECIMAL (20,5)Reserved for IBM internal use.
RULETEXTVARCHAR (4000)Reserved for IBM internal use.
FIELD1BIGINTReserved for IBM internal use.
FIELD2DECIMAL (20,5)Reserved for IBM internal use.
FIELD3VARCHAR (254)Reserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RULE_IDPrimary Key
I0000080RULENAME+OWNER_IDUnique Index
I0000081RULETYPENon-Unique Index
I0000540ADMIN_IDNon-Unique Index
I0000541OWNER_IDNon-Unique Index
I0001250CLASS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_254CLASS_IDRULECLSREGRULECLASS_IDCascade
F_255OWNER_IDMEMBERMEMBER_IDCascade
F_256ADMIN_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_81RULE_IDAUCTIONBIDRULE_IDCascade
F_94RULE_IDAUCTSTYLERULE_IDCascade