| id |
int(10)
|
|
|
|
| itemtype |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| items_id |
int(10)
|
|
|
|
| notificationtemplates_id |
int(10)
|
|
|
|
| entities_id |
int(10)
|
|
|
|
| is_deleted |
tinyint(4)
|
|
|
|
| sent_try |
int(11)
|
|
|
|
| create_time |
timestamp
|
|
|
|
| send_time |
timestamp
|
|
|
|
| sent_time |
timestamp
|
|
|
|
| name |
text
|
utf8mb4_unicode_ci
|
|
|
| sender |
text
|
utf8mb4_unicode_ci
|
|
|
| sendername |
text
|
utf8mb4_unicode_ci
|
|
|
| recipient |
text
|
utf8mb4_unicode_ci
|
|
|
| recipientname |
text
|
utf8mb4_unicode_ci
|
|
|
| replyto |
text
|
utf8mb4_unicode_ci
|
|
|
| replytoname |
text
|
utf8mb4_unicode_ci
|
|
|
| headers |
text
|
utf8mb4_unicode_ci
|
|
|
| body_html |
longtext
|
utf8mb4_unicode_ci
|
|
|
| body_text |
longtext
|
utf8mb4_unicode_ci
|
|
|
| messageid |
text
|
utf8mb4_unicode_ci
|
|
|
| documents |
text
|
utf8mb4_unicode_ci
|
|
|
| mode |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| event |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
