Database – SMS trigger Entity (sms_trigger_entity)
SMS notification trigger settings.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
title | varchar(100) | The name/title of the entity instance | ||
sbt_template_id | int(11) | sbt template id | ||
sbt_template_type | char(20) | sbt template type | ||
trigger_rule | text | trigger rule | ||
restriction_rule | text | restriction rule | Clojure | |
state | text | trigger state | ||
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 |