Project Data Tables Database > td Schema : td.RULES Table |
Information on alerts generated according to these rules is stored in the ALERT Table.
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
RL_ID | The record ID. | int | 4 | ||||
RL_CONDITION | An XML description either of an entity or an entity’s value. When the entity changes or when the value of the entity changes to the specified value, the alert is triggered. | varchar | 16 | ||||
RL_ACTION | The XML specification of the action to perform when the alert is triggered. | varchar | 16 | ||||
RL_RECIPIENT | Specifies the role of the users who receive the notice. | varchar | 16 | ||||
RL_DESCRIPTION | A description of the alert. | varchar | 16 | ||||
RL_TO_MAIL | If Y, an alert is emailed to the recipients defined in the administration console. | varchar | 1 | ||||
RL_IS_ACTIVE | If Y, the rule is active. | varchar | 1 | ||||
RL_IS_PREDEFINED | For future use. | varchar | 1 |
Index | Description | Primary | Unique |
---|---|---|---|
RL_PRIMARYKEY |