CATGRPRULE

Relates a category to a web activity.

Column Descriptions:

NameTypeDescription
CATGROUP_IDBIGINT NOT NULLThe catalog group ID the rule belongs to.
DMACTIVITY_IDINTEGER NOT NULLThe web activity ID representing the rule for this category.
EVALTIMETIMESTAMPThe last time this category had its rule evaluated.
SHOWAFTERSMALLINT NOT NULL DEFAULT 0This is a flag indicating that this rule was configured with some information that requires a web activity lookup. This is used for performance.
  • 0: Rule requires web activity lookup.
  • 1: Rule does not require web activity lookup.
EVALUATINGSMALLINT NOT NULL DEFAULT 0The current status of the rule evaluation for this category:
  • -1: The rule should never be evaluated for this category. This is used for the non-dynamic category.
  • 0: Rule is currently not being evaluated for this category, and it is ready to be evaluated after the next configured interval.
  • 1: Rule is currently being evaluated for this category
  • 2: Rule is flagged as needing evaluation, and ignore configured time interval.
  • -2: The last evaluation of the rule has failed.
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
P_0031CATGROUP_ID+DMACTIVITY_IDPrimary Key
I0001520DMACTIVITY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3770CATGROUP_IDCATGROUPCATGROUP_IDCascade