Database – Notification Entity (notification_entity)
Description
This table holds records of notifications that have been sent to a user, and the status of the notification.
Table Fields
Field | Data Type | Column Info | Value Notes |
id | int(11) | The id of the entity | |
user_id | int(11) | ID of the associated agent user | |
loan_id | int(11) | The id of the associated loan account | |
loan_type | varchar(100) | The loan type | Default is set to: Entity.Loan |
name | varchar(100) | Entity name | |
type | varchar(100) | notification type | |
metadata | text | notification metadata | |
is_read | tinyint(1) | Whether or not is read | 1 - yes, 0 - no |
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 |