Table: Delivery Entity

Table: Delivery Entity

Holds metadata about how to notify agent users when an event happens.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
namevarchar(255)Entity name
descriptionvarchar(255)The description of the entity instance
blurbvarchar(255)Delivery Blurb
short_blurbvarchar(100)Short delivery blurb
typechar(27)Delivery typenotification.type.*
eventchar(50)trigger event
ruletextAssociated Clojure Rule used in entity evaluation
custom_definitiontextCustom definition
ntf_visibletinyint(1)NTF visible1 - yes, 0 - no
ntc_visibletinyint(1)NTC visible1 - yes, 0 - no
email_idint(11)Email ID
web_idint(11)Web ID
sms_idint(11)SMS ID
activetinyint(1)Whether or not the entity is active1 - yes, 0 - no
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List