Notificaion
DB Schema
- notification_list
| Column Name | Type | Not Null | PK | auto increment | Index | Notes |
|---|---|---|---|---|---|---|
| host | string | Y | Y | Y | Y | |
| port | integer | |||||
| secure | boolean | |||||
| user_name | string | |||||
| password | string(md5) | 加密方式1. md5, 2. jwt token with secret | ||||
| from_mail_addr | string | |||||
| subject | string |
- alarm_notification
| Column Name | Type | Not Null | PK | auto increment | Index | Notes |
|---|---|---|---|---|---|---|
| alarm_id | integer | Y | Y | |||
| notification_id | integer | Y | Y | |||
| trigger_type | integer | Y | Y | {1: happend} |
sys_parameters
- NOTIFICATION_MAX_COUNT: 32
scope
加上system_setting
migrate裡也要加，參考manager_alarm
others
- sendList的上限也是32