| 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 | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| ear_created | timestamp | YES | CURRENT_TIMESTAMP | | | |