_999.encounters_alert_rules
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| ear_id | int(11) | NO | PRI | auto_increment | ||
| ear_cus_id | int(11) | NO | Customer ID | |||
| ear_cli_id | int(11) | NO | Client ID | |||
| ear_name | text | YES | Name for the rule | |||
| ear_description | text | YES | Short description of the rule | |||
| ear_rule | text | YES | The text version of the rule logic | |||
| ear_message | text | YES | The message displayed in this alert | |||
| ear_usr_id_created | int(11) | YES | User ID of user who created the rule | |||
| ear_disabled | tinyint(1) | YES | 0 | |||
| ear_modified | datetime | YES | CURRENT_TIMESTAMP | |||
| ear_created | datetime | YES | CURRENT_TIMESTAMP |
References
| Local Column | References | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ear_id |
|