Database – Email Trigger entity (email_trigger_entity)
Description
This holds email trigger information. When the trigger is matched, an email is sent out to the specified recipients.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
company_email_id | int(11) | Company Email ID | ||
trigger_rule | text | trigger rule | Clojure | |
title | varchar(100) | The name/title of the entity instance | ||
restriction_rule | text | restriction rule | Clojure | |
state | text | State of the email trigger | geo.state.*; geo.province.* | |
email_subject | varchar(255) | email subject | ||
email_content | text | email content | ||
email_deliver | varchar(100) | email deliver notification type | email.notification.* | |
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |