Relates a category to a web activity.
Column Descriptions:
| Name | Type | Description |
| CATGROUP_ID | BIGINT NOT NULL | The catalog group ID the rule belongs to. |
| DMACTIVITY_ID | INTEGER NOT NULL | The web activity ID representing the rule for
this category. |
| EVALTIME | TIMESTAMP | The last time this category had its rule
evaluated. |
| SHOWAFTER | SMALLINT NOT NULL DEFAULT 0 | This 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.
|
| EVALUATING | SMALLINT NOT NULL DEFAULT 0 | The 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.
|
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| P_0031 | CATGROUP_ID+DMACTIVITY_ID | Primary Key |
| I0001520 | DMACTIVITY_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3770 | CATGROUP_ID | CATGROUP | CATGROUP_ID | Cascade |