CONTRLRULE

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

Column Descriptions:

NameTypeDescription
RULE_IDBIGINT NOT NULLReserved for HCL internal use.
OWNER_IDBIGINT NOT NULLReserved for HCL internal use.
CLASS_IDBIGINT NOT NULLReserved for HCL internal use.
ADMIN_IDBIGINTReserved for HCL internal use.
RULETYPECHAR (4) NOT NULLReserved for HCL internal use.
RULENAMECHAR (30) NOT NULLReserved for HCL internal use.
RULEDESCVARCHAR (254)Reserved for HCL internal use.
MINQUANTDOUBLEReserved for HCL internal use.
MINVALUEDECIMAL (20,5)Reserved for HCL internal use.
RULETEXTVARCHAR (4000)Reserved for HCL internal use.
FIELD1BIGINTReserved for HCL internal use.
FIELD2DECIMAL (20,5)Reserved for HCL internal use.
FIELD3VARCHAR (254)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL 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