notification_entity - Notification Entity

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


How did we do?


Powered by HelpDocs (opens in a new tab)