Database – User Delivery Relation (user__delivery)
Updated 2 years ago
Maps agent users to notification deliveries.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
parent_id | int(11) | ID of parent category | ||
user_id | int(11) | ID of the associated agent user | ||
parent_type | varchar(30) | Type of parent | ||
restriction | text | restriction | ||
restriction_ui | text | restriction (UI) | ||
rule | text | Associated Clojure Rule used in entity evaluation | ||
ntf_visible | tinyint(1) | NTF visible | 1 - yes, 0 - no | |
ntc_visible | tinyint(1) | NTC visible | 1 - yes, 0 - no | |
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | varchar(19) | Whether or not the entity was deleted | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |