email_trigger_entity - Email Trigger entity

This holds email trigger information. When the trigger is matched, an email is sent out to the specified recepients.

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


How did we do?


Powered by HelpDocs (opens in a new tab)