Database – Delivery Entity (delivery_entity)
Description
Holds metadata about how to notify agent users when an event happens.
Table Fields
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
name | varchar(255) | Entity name | ||
description | varchar(255) | The description of the entity instance | ||
group | varchar(41) | Delivery group | ||
sub_group | varchar(45) | Delivery subgroup | ||
blurb | varchar(500) | Delivery Blurb | ||
short_blurb | varchar(100) | Short delivery blurb | ||
type | char(27) | Delivery type | notification.type.* | |
event | char(50) | trigger event | ||
rule | text | Associated Clojure Rule used in entity evaluation | ||
custom_definition | text | Custom definition | ||
ntf_visible | tinyint(1) | NTF visible | 1 - yes, 0 - no | |
ntc_visible | tinyint(1) | NTC visible | 1 - yes, 0 - no | |
delivery_applies_for | varchar(50) | Type of entity the delivery applies to | ||
email_id | int(11) | Email ID | ||
web_id | int(11) | Web ID | ||
sms_id | int(11) | SMS ID | ||
mail_house_id | int(11) | Mail House ID | ||
webhook_id | int(11) | Webhook ID | ||
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 |