Database – Notification Entity (notification_entity)
Updated 3 months ago
Holds a notification that has been sent to a user, and the status of the notification.
Column | Data Type | Column Info | Value Notes | Other |
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 | ||
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 |